Forum Discussion

Danger_SF's avatar
Danger_SF
Brass Contributor
Jan 16, 2023
Solved

Conditional formatting - Multiple text values for a single rule

So, I know how to make any cell with the text, "Barney", automatically change its format to fill purple.

 

Is there a way to have the cell format fill purple if the text is either Barney, Fred, or Wilma? Thank you.

  • Patrick2788's avatar
    Patrick2788
    Silver Contributor

    Danger_SF 

    Use Conditional Formatting with a formula and try this one:

     

    =OR($A1="Fred",$A1="Barney",$A1="Wilma")

     

     

Resources