| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditionally formatting colour of cells
Is there a way to automate the colour of a cell based on the value of another
cell even though the cell I'm colouring has its own formula already? For example, if a21 is a positive number, I want b21 to be green. If a21 is negative, I want b21 to be red. If it's 0 then white. But B21 is already a sum total of something else so I don't want to disrupt that formula |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formatting colour in cells when one cell contains a character | Excel Worksheet Functions | |||
| Conditionally Formatting Cells based on Values in a Range (2007) | Excel Worksheet Functions | |||
| conditionally formatting cells based on other cells | Excel Discussion (Misc queries) | |||
| Toggle Cell Colour Conditionally | Excel Worksheet Functions | |||
| Conditionally formatting other cells? | Excel Worksheet Functions | |||
Threaded Mode
