conditional format using "OR"?
I have a set of data, there are a few possible entries:
S
V
A
P
E [NUMBER]
T [NUMBER]
A [NUMBER]
I would like to have the S, V, and P cells all be one colour and the rest be
another colour. How would I define the conditional formatting to make this
work?
thanks
|