Ref Chip's reply:

You can get a 4th color by formatting negative numbers to be a
different color than default black (usually red). This works in
addition to the conditional formatting. This does require that your
values include one negative number. This just changes the text,
though, not the cell background.

---Glenn


--
gjcase
------------------------------------------------------------------------
gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061
View this thread: http://www.excelforum.com/showthread...hreadid=507781