Conditional Formatting comparing multiple values
If 'Formula is' =OR($C1="Newsprint
Total","$C1="Specialties Total")
-----Original 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!
.
|