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
If Column U =A and Column W = 533 I want the cell to turn light red
Microsoft Excel
Last Comment
ca1358
ASKER
I tried all kinds of things and nothing is working. Here is a screen shot of it.
ExcelConditionalFormatingdocx.docx
ExcelConditionalFormatingdocx.docx
Sorry my bad, this works:
=AND(IF($U1="A",TRUE,FALSE),IF($W1=533,TRUE,FALSE))
Or this:
=AND($U1="A",$W1=533)
ASKER
Still no luck including a file
TestConditionalFormatting.xls
TestConditionalFormatting.xls
Works for me.
TestConditionalFormatting.xls
TestConditionalFormatting.xls
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
Included Snapshot.
How-do-you-make-it-read-only-col.docx
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thank you!
=AND($U1="A",$W1="533")