The absence of any formatting on the cell could be a fourth "conditional
format," but this is a dicey solution that may not be workable for you.

More likely, you'll need to use VBA to achieve this result.
--
HTH -

-Frank Isaacs
Dolphin Technology Corp.
http://vbapro.com


"Jody" wrote in message
...
I have a user who has a need to use conditional formatting
on more than three conditions. This would be simple if
the condition was only looking at the value of a
particular cell. Unfortunately, what he is doing is more
complicated.