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