Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Did not manage to do it that way.
I ended up calling the blank cells "z" (say) and then by colouring the cells green to begin with, I used the 3 conditions to 1.) colour any z's with a white background and white font 2.) highlight in amber -1's and 0's 3.) highlight in red values less than -1. Messy but it finally worked. Thanks for the other tips, will come in useful. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I count conditional blank cells? | Excel Worksheet Functions | |||
Applying conditional formatting to cell based on another cell's in | Excel Discussion (Misc queries) | |||
Conditional formatting blank cells | Excel Discussion (Misc queries) | |||
Conditional Formatting Blank =white.. but 4 conditions | Excel Worksheet Functions | |||
bolding cells in conditional formatting | Excel Worksheet Functions |