| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do i change the colour of a cell according to the contents
Thank you very much, very helpful
Thanks ChrisC |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change colour in cell | Excel Worksheet Functions | |||
| excel - formula to copy the cell contents and colour. Possible? | Excel Discussion (Misc queries) | |||
| Changing Cell Contents Colour | Excel Discussion (Misc queries) | |||
| change a cell background colour to my own RGB colour requirements | Excel Discussion (Misc queries) | |||
| Change cell colour | Excel Worksheet Functions | |||
Hybrid Mode
