How do i change the colour of a cell according to the contents?

[ChrisC]

i am trying to change the clour of a cell to r if the number is negative and
green if the number is positive. Can i do this ?
Help much appreciated.

 

[Kevin B]

Look up Conditional Formatting in help for instructions on how to do this.
And for some tips on usage go to this website an lookup Conditional
Formatting in the index under C

http://www.contextures.com/tiptech.html

 

[ChrisC]

Thank you very much, very helpful

Thanks
ChrisC