How can I deactivate conditional formatting if the cell is empty?
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
|