Changing colors of cells to establish value.

  • Thread starter Thread starter MARK
  • Start date Start date
M

MARK

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.
 
You want CONDITIONAL FORMATING. Look it up in Help; it's
easier than it looks. The basic idea is to set a formula
refering the cell that will change the formatting to
whatever you set when a condition tests positive.
 
Mark,

With conditional formatting. Just set the value of equal to 1000 and format
to suit. Another condition equal to 500, and a third to a value equal
to -1000.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top