More that 3 conditions for conditional formating?
Hi,
Thanks I will give this a try. I also found a Macro the does it also, it
will just take some time to figure out how to manipulate it. I do not know
how to write macros so it is trial and error for me.
Thank,
Jerry
"Jezebel" wrote in message
...
Use a second cell to evaluate all your conditions
=IF ( AND ( cond1, cond2, cond3, cond4, ....), TRUE)
Then base your conditional format on that cell.
"Jerry Kinder" wrote in message
...
How do I set more that 3. I need 6 or 8.
I want to have color of cell change if one of the 6 or 8 words appears
in
the cell.
Thanks,
Jerry
|