Link to home
Start Free TrialLog in
Avatar of ca1358
ca1358

asked on

Excel Conditional formatting

how do you use conditional formatting for following Which has two criteria?

If Column U =A and Column W = 533 I want the cell to turn light red
Avatar of Joe Howard
Joe Howard
Flag of United States of America image

Use this formula for the rule
=AND($U1="A",$W1="533")
Avatar of ca1358
ca1358

ASKER

I tried all kinds of things and nothing is working.  Here is a screen shot of it.
ExcelConditionalFormatingdocx.docx
Sorry my bad, this works:
=AND(IF($U1="A",TRUE,FALSE),IF($W1=533,TRUE,FALSE))

Open in new window

Or this:
=AND($U1="A",$W1=533)

Open in new window

Avatar of ca1358

ASKER

Still no luck including a file
TestConditionalFormatting.xls
Avatar of ca1358

ASKER

How do you make it Highlight only column U and Column W and not Column V included

Included Snapshot.
How-do-you-make-it-read-only-col.docx
ASKER CERTIFIED SOLUTION
Avatar of Joe Howard
Joe Howard
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ca1358

ASKER

Thank you!