Changing Celll colour as a result of a calculation

  • Thread starter Andy_Oscar_Charlie
  • Start date
A

Andy_Oscar_Charlie

When performing a calculation I want to change the colour of the cell to Red
if negative or Green if positive.
 
M

Marcelo

hi,

use conditional format to do this.

go to menu format --> conditional format

Condition 1
Cell value is Less than 0
Format as you want,

condition 2
cell value is greather than or equal to 0
Format as you want

hth




--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Andy_Oscar_Charlie" escreveu:
 
J

John C

Actually, it depends on how he wants to handle any 0 response. 0 isn't a
positive number.
 
Top