Thread: How do i change the colour of a cell according to the contents?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
  
Posts: 1,316
Default 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.
Reply With QuoteReply With Quote