Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Add that stipulation to your CF formula.
For example: =AND(A1<"",A1<B1) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Vahe" wrote in message ... I have a range of cells where I am using conditional formatting. I would like to "turn off" or "deactivate" conditional formatting while the cell(s) are empty. I only want conditional formatting to apply where the cells are NOT null. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional formatting similar to shading alternating rows | Excel Worksheet Functions | |||
Conditional Formatting if cell content is a formula | Excel Worksheet Functions | |||
Merged Cell Conditional Formatting Borders | Excel Discussion (Misc queries) | |||
BULK Conditional Formatting - by column without going into each cell? | Excel Discussion (Misc queries) | |||
Why won't my conditional formatting display in the cell | Excel Discussion (Misc queries) |