Conditional formatting - Multiple text values for a single rule

[Danger_SF]

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.

[#2 · Accepted solution]

@Danger_SF 

Use Conditional Formatting with a formula and try this one:

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

[#3]

Thanks for the great support as always.