Conditional Formatting
Thanks to Stephen, it works.
"Stephen" wrote:
For conditionally formatting cell A1, use
=OR(A1="A",A1="B",A1="C",A1="D",A1="E")
"yclhk" wrote in message
...
Thanks for all. I think the solution of using OR function is more simple.
However, how to compose the formula in this formatting ?
Thanks again for your help,
"David Biddulph" wrote:
If you do mean that you want one designated format if the cell value is
A,
B, C, D, or E, then you can use an OR function in your conditional
formatting condition. Use Formula Is, not Cell Value Is.
--
David Biddulph
"yclhk" wrote in message
...
How to include more than 3 conditions for formatting the cell ?
For example: if the cell values are A, B, C, D or E, the cell displays
in
a
designated format.
|