Changing colours using formulae

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

Hi,

I want to make a colour appear black if it's positive and
red if it's negative, any ideas?

Many thanks

Jeff Andrews
 
Hi

If you make the whole range the colour you want for your positive values,
you can then go to Format / Conditional Format to set the colour for your
negatives:
Cell Value Is Less Than 0
What happens if the value is zero by the way? You may want to leave the
column white and have 2 CFs, one for positive and one for negative.
 
Many thanks that's great
-----Original Message-----
Hi

If you make the whole range the colour you want for your positive values,
you can then go to Format / Conditional Format to set the colour for your
negatives:
Cell Value Is Less Than 0
What happens if the value is zero by the way? You may want to leave the
column white and have 2 CFs, one for positive and one for negative.

--
Andy.





.
Click to expand...
 
Back
Top