One way is to upgrade to XL2007.

otherwise, you will probably have to use worksheet event code. Perhaps
something like this (put it in your worksheet code module: Right-click
on the worksheet tab and choose View Code):

There are tons of posts of ways to use event code in the archives:

http://groups.google.com/advanced_group_search?

(in addition to your search terms, enter *excel* (with asterisks) in the
group box)


In article ,
Alison wrote:

Is there any way to increase from "3" the number of conditional format
arguments allowed?

I have 4 arguments and the cells this applies to will contain one of the 4
arguments or be blank. If the cell is blank, no conditional formatting
should be applied. For each of the 4 arguments, a different cell pattern
colour would be applied.

Thanks!