A Andy_Oscar_Charlie Oct 9, 2008 #1 When performing a calculation I want to change the colour of the cell to Red if negative or Green if positive.
When performing a calculation I want to change the colour of the cell to Red if negative or Green if positive.
M Marcelo Oct 9, 2008 #2 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:
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 Oct 9, 2008 #3 Actually, it depends on how he wants to handle any 0 response. 0 isn't a positive number.
