colors

[Gabbi]

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
negative balance (-0.01) in red.

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

Please help.

 

[bj]

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

 

[olasa]

Format the cell with Custom Format: [$$-2] # ##0.00_);[Red]([$$-2]
##0.00)
Right click on the cell, Format Cells...>Select ta
Number>Category:Custom and then copy and past in the above.

HTH
Ola Sandströ

 

[Gabbi]

CUSTOM FORMAT!

Why didn't figure this out before! I was trying to make this so muc
harder. Thanks! :

 

[olasa]

Thanks for the feedback
Ol