Cell colour in relation to IF results

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

I want a cell to be coloured red if the result of a simple calculation is
negative, and coloured green if the result is positive. Can anyone tell me
how to do this?
 
Use Conditional Formatting.
Cell Value "less than" 0 and set format to red (font or fill), then add
a second condition
Cell Value "greater than" 0 and set the format to green.
 
Hi,
use conditional formating, where the formula is enter

=$C$1>0 choose color green

do the same again enter formula

=$C$1<0 choose color red
 
Back
Top