Changing colors of cells to establish value.

Giganews Newsgroups
Subject: Changing colors of cells to establish value.
Posted by:  MARK (STARFINANCIALGRO…@YAHOO.COM)
Date: Mon, 6 Oct 2003

Hello,

Can I program my cells to establish a color of the cell
and/or the color of the font according to the value of the
cell.  ie: If I have a formula that has a product being
sold at 5000.00 with a cost of 4000.00, in another 5000.00
sale with a 4500.00 cost, and in another a 5000.00 sale
with a 6000.00 cost.  Could I show these with the 1000.00
profit showing in one color automatically, if the cost
changed to the second, could I show the 500.00 profit as
another.  If it changed to the 1000.00 loss, could it
change to another color?

thanks,

Mark.

Replies