View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default 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