Same Conditional Formating on Multiple Values 1

[ccepaulb]

I'm trying to use the "Or" function within conditional formating in Excel.
I have the following in my condition:

Condition 1
Formula is =OR($C9="Red Man","Red Man Golden Blend")
but it isn't working right. What I want to do is have either of those values trigger the same format for the cells.
I'd just add another condition, but I have 6 brands I want to format against and Excel only allows 3 conditions within my version.

Any suggestions?

 

[jasonwooten]

tell me what you are looking for and send the spreadsheet to jasonwooten@cinram.com..

I will look at it and get you either some code or a macro..

 

[Zathras]

You were close. The syntax for the OR function was wrong, try this:

=OR($C9="Red Man",$C9="Red Man Golden Blend")