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.

2 Replies
best response confirmed by Danger_SF (Contributor)


Use Conditional Formatting with a formula and try this one:





Thanks for the great support as always.