Conditional Formatting based on multiple fields

[Laura408]

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

[#2]

@Laura408 

this should work for you

[#3]

@Jagodragon 

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

[#4 · Accepted solution]

@Laura408 

Use

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

[#5]

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