Ola,

OK, thanks for your help, I suspected the answer to be as much, and
will look into the three options you provided.

However, in the mean time, I think I've come up with a crude solution -
the cell format can be set to option number 1 through format cells. The
remaining three options can be set through conditional formating. If
none of the conditional formatting criteria are met, then it defaults
to the original formatting as set through format cells.

Thus 4 different formats are possible.


--
stevepain
------------------------------------------------------------------------
stevepain's Profile: http://www.excelforum.com/member.php...o&userid=21759
View this thread: http://www.excelforum.com/showthread...hreadid=390557