| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell colour in relation to IF results
I want a cell to be coloured red if the result of a simple calculation is
negative, and coloured green if the result is positive. Can anyone tell me how to do this? -- Thanks for your help Rob |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell colour in relation to IF results
Use Conditional Formatting.
Cell Value "less than" 0 and set format to red (font or fill), then add a second condition Cell Value "greater than" 0 and set the format to green. "Rob" wrote: I want a cell to be coloured red if the result of a simple calculation is negative, and coloured green if the result is positive. Can anyone tell me how to do this? -- Thanks for your help Rob |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell colour in relation to IF results
Hi,
use conditional formating, where the formula is enter =$C$10 choose color green do the same again enter formula =$C$1<0 choose color red "Rob" wrote: I want a cell to be coloured red if the result of a simple calculation is negative, and coloured green if the result is positive. Can anyone tell me how to do this? -- Thanks for your help Rob |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can colour of cell shading be fixed to one colour | Excel Discussion (Misc queries) | |||
| List or colour Cells of results | Excel Worksheet Functions | |||
| change a cell background colour to my own RGB colour requirements | Excel Discussion (Misc queries) | |||
| Cell relation ships. | Excel Discussion (Misc queries) | |||
| can i colour a cell on basis of results of a formula e.g clour bl. | Excel Worksheet Functions | |||
Linear Mode
