you can either use Format-cells-custom and select one that gives what you
want, or you can used format-conditional formating
check the discussion in help

"Gabbi" wrote:


I am looking for a way to color code a total. For accounting purposes,
if the total is below $0.0 I would like to create a function to show a
negative balance (-0.01) in red.

I am aware that colorsindex ranges can be configured by the position in
the color pallet. I've read about some examples of help using a
'sumbycolor' function. Such as http://www.cpearson.com/excel/colors.htm
but I'm not sure where to start.

Please help.

G


--
Gabbi
------------------------------------------------------------------------
Gabbi's Profile: http://www.excelforum.com/member.php...o&userid=25654
View this thread: http://www.excelforum.com/showthread...hreadid=390668