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

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.

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

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
--
Kevin Backmann


"ChrisC" wrote:

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.

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

Thank you very much, very helpful

Thanks
ChrisC