CODEWITHSUNDEEP
excelexcel-formulaconditional-formatting
Windfall
Windfall

Reputation: 15

Conditional Formatting based on TWO Adjacent Cell Value

The goal is to highlight value in Column A5 Green, if the values in both B5 and C5 have the value "Confirmed" then also have the same mythology for A6 - A19

I tried using if statements, but it was not working

enter image description here

Upvotes: 0

Views: 37

Answers (1)

BigBen
BigBen

Reputation: 50008

Use AND:

=AND(B5="Confirmed",C5="Confirmed")

and apply this rule to range A5:A19.

Upvotes: 2

Related Questions