Forum Discussion
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.
Use Conditional Formatting with a formula and try this one:
=OR($A1="Fred",$A1="Barney",$A1="Wilma")
Use Conditional Formatting with a formula and try this one:
=OR($A1="Fred",$A1="Barney",$A1="Wilma")- Thanks for the great support as always.
