In Excel 2007 you can have more than three conditions but earlier versions
have a limit of three...

What people do is use three conditions through conditional formatting and
three through Cell Formatting (which is much more limited)

"LinLin" wrote:

Is it possible to do a form of conditional formatting where you have more
than 3 conditions?
I had a quick look through the existing solutions in the discussion group
but I get the impression the answer is no....

And if it is yes, it's not using the Conditional Formatting tool but maybe
VBA?
thanks!