Forum Discussion

Laura408's avatar
Laura408
Copper Contributor
Jul 15, 2022
Solved

Conditional Formatting based on multiple fields

Trying to highlight cells in columns B & C if Cell in column E contains "Car" and Cell in column H = "GA"      
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Jul 15, 2022

    Laura408 

    Use

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

Laura408's avatar
Laura408
Copper Contributor
Jul 15, 2022

Jagodragon 

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

HansVogelaar's avatar
HansVogelaar
MVP
Jul 15, 2022

Laura408 

Use

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

  • Laura408's avatar
    Laura408
    Copper Contributor
    Jul 15, 2022
    Thank you so much!!! That's what I needed.

Resources