Forum Discussion
Danger_SF
Jan 16, 2023Brass Contributor
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")
- Patrick2788Silver Contributor
Use Conditional Formatting with a formula and try this one:
=OR($A1="Fred",$A1="Barney",$A1="Wilma")
- Danger_SFBrass ContributorThanks for the great support as always.