SOLVED

Conditional Formatting based on multiple fields

New Contributor

Trying to highlight cells in columns B & C if Cell in column E contains "Car" and Cell in column H = "GA"

Laura408_2-1657896792099.png

 

 

 

4 Replies

@Laura408 

 

this should work for youEXCEL_wJqxLrCiaD.png

@Jagodragon 

Thank you, but how do I add the second requirement, Cell in column H = "GA" ?

best response confirmed by Laura408 (New Contributor)
Solution

@Laura408 

Use

=AND(ISNUMBER(SEARCH("Car",$C2)),$H2="GA")

Thank you so much!!! That's what I needed.