You can use conditional formatting to generate 3 *_formats_*.
Add that to the basic format setting on the cell, and it gives you a total
of 4.
With a VB event procedure you can have as many formats as you want.

But the number of *_conditions_* is another matter.
Imagine you want to turn the cell green if any one of 5 conditions are met.

You would do:
Formula is
=OR(condition1,condition2,condition3,condition4,co ndition5)

condition1 might be something like
B2="hello"

does that help?

--
Allllen


"Al_Doug" wrote:

Using Conditional formatting, I can only create up to three conditions. Can
I use formulas or VB code to exceed three conditions?

Thanks.