| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Celll colour as a result of a calculation
When performing a calculation I want to change the colour of the cell to Red
if negative or Green if positive. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing Celll colour as a result of a calculation
hi, use conditional format to do this. go to menu format -- conditional format Condition 1 Cell value is Less than 0 Format as you want, condition 2 cell value is greather than or equal to 0 Format as you want hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Andy_Oscar_Charlie" escreveu: When performing a calculation I want to change the colour of the cell to Red if negative or Green if positive. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing Celll colour as a result of a calculation
Actually, it depends on how he wants to handle any 0 response. 0 isn't a
positive number. -- John C "Marcelo" wrote: hi, use conditional format to do this. go to menu format -- conditional format Condition 1 Cell value is Less than 0 Format as you want, condition 2 cell value is greather than or equal to 0 Format as you want hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Andy_Oscar_Charlie" escreveu: When performing a calculation I want to change the colour of the cell to Red if negative or Green if positive. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing Celll colour as a result of a calculation
Two options:
Conditional formatting or Format/ Cells/ Number/ Custom -- David Biddulph "Andy_Oscar_Charlie" wrote in message ... When performing a calculation I want to change the colour of the cell to Red if negative or Green if positive. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing all cells in one colour to a different colour | Excel Discussion (Misc queries) | |||
| need the result after using formula in deffrent colour | Excel Worksheet Functions | |||
| Adding colour to result in a cell? | Excel Discussion (Misc queries) | |||
| How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
| How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
Hybrid Mode
