| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
fill cell with colour if preceding cell is a negative value
Select cell you want to format select format, conditional format, formula
then =a1<0 then select format pattern select color you want "POP" wrote: If cell c3 is a negative value how do I colour c4 automatically? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell colour fill | Excel Discussion (Misc queries) | |||
| Change the colour of numbers in a cell if the number is negative | Excel Worksheet Functions | |||
| How to make a cell copy the fill colour of another cell | Excel Worksheet Functions | |||
| Fill colour a cell from the linked cell | Excel Discussion (Misc queries) | |||
| How to Blink a cell in Excel if negative or red colour | Excel Discussion (Misc queries) | |||
Hybrid Mode
