Conditional formatting disappears when cell contents deleted

[wardw]

I'm having a problem with a conditional format formula disappearing fro
a cell when I paste another cell's contents into it and then delete th
content.

I always thought that conditional format formulas were separate fro
regular cell contents (like numbers, text, formulas). So if I have
conditional format in a cell, then put some content in it, then delet
the content, the conditional format should still apply to that cell.

I have a red border conditional format in a cell, that says if the cel

0 (i.e., if there's content in it) the border should not appear. Th

CF rule works fine, and when I paste the content of another cell int
the CF cell the border disappears as it should. But then, if I delet
the content, the CF format disappears from the cell: The Conditiona
Formatting Rules dialog box shows no formula is in that cell.

The cell whose contents I copied had no conditional format.

In case it's useful, here's the CF formula:

=IF(AND($K$192>0,$L$192>0,$M$192=0),TRUE,FALSE)

All cells involved have a standard format as well; they're all dat
formats. I'm using Excel 2007

 

[Claus Busch]

Hi,

Am Sat, 21 Jul 2012 17:04:30 +0000 schrieb wardw:

I'm having a problem with a conditional format formula disappearing from
a cell when I paste another cell's contents into it and then delete the
content.

if you paste another cells contents you paste all, also the cells
format. Therefore the CF disappears. Copy the cell and then Paste
Special => Paste values.
And the formula for CF you can shorten:
=AND(K192*L192>0,M192=0)

Regards
Claus Busch

 

[wardw]

Thank you, Spencer101 and Claus Busch; I'm now using Paste Special =
Paste Values and the CF remains in the cell. And thanks for your shorte
formula, Claus; it works fine.