How can I deactivate conditional formatting if the cell is empty?
 

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

How can I deactivate conditional formatting if the cell is empty?
 

Select the cells while they don't have anything in them and use regular cell
formatting to 'instruct' Excel how to display them when the conditions
controlling conditional formatting are not met?

"Vahe" wrote:

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

How can I deactivate conditional formatting if the cell is empty?
 

You can achieve this by setting your conditional format to trigger on
"Formula is" rather than "Cell Value is". Write an AND statement like
this:
=AND(C8<"",C8="abc")

This triggers the conditional format in cell C8 when that cell is not
blank and when it contains the entry abc. If the cell is blank the AND
formula is false and does not trigger the conditional formatting.

Dave O

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