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
Microsoft Excel

Avatar of undefined
Last Comment
ca1358

8/22/2022 - Mon
Joe Howard

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

ASKER
I tried all kinds of things and nothing is working.  Here is a screen shot of it.
ExcelConditionalFormatingdocx.docx
Joe Howard

Sorry my bad, this works:
=AND(IF($U1="A",TRUE,FALSE),IF($W1=533,TRUE,FALSE))

Open in new window

I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
Joe Howard

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

Open in new window

ca1358

ASKER
Still no luck including a file
TestConditionalFormatting.xls
Joe Howard

⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
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
Joe Howard

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.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
ca1358

ASKER
Thank you!