Conditional Formatting comparing multiple values
=OR($C1="Newsprint Total",$C1="Specialties Total")
--
Regards,
Tom Ogilvy
"Erin" wrote in message
...
I have a conditional format set as follows:
If 'Formula is' = $C1 = "Newsprint Total"
This format is applied to all of column C. I want to have this do an
'or' so that it can say if the value is "Newsprint Total" OR "Specialties
Total".
How can I put an 'OR' here. I don't want to do another condition
statement because I already have 3, and the "Specialties Total" will use the
same format!
|