Conditional Formatting - new data
 

Excel 2007

I have multiple conditional formatting schemes set up for worksheet. When I
paste new data into the sheet, how do I apply the formatting? It disappears
when I paste and the only way I can apply it is to re-select the ranges.
What am I missing?

Conditional Formatting - new data
 

Paste special as values


--


Regards,


Peo Sjoblom




"jmegdan1" wrote in message
...
Excel 2007

I have multiple conditional formatting schemes set up for worksheet. When
I
paste new data into the sheet, how do I apply the formatting? It
disappears
when I paste and the only way I can apply it is to re-select the ranges.
What am I missing?

Conditional Formatting - new data
 

EditPasteSpecialValues instead of paste

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"jmegdan1" wrote in message
...
Excel 2007

I have multiple conditional formatting schemes set up for worksheet. When
I
paste new data into the sheet, how do I apply the formatting? It
disappears
when I paste and the only way I can apply it is to re-select the ranges.
What am I missing?

Conditional Formatting - new data
 

Ok. Found the problem. Deleted previous rows and added new data. CF
formula reflects the gap of the deleted rows. Is there a way to lock the
condition ranges? I suppose I could just highlight cells and delete but
there is a lot of data.

"jmegdan1" wrote:

Excel 2007

I have multiple conditional formatting schemes set up for worksheet. When I
paste new data into the sheet, how do I apply the formatting? It disappears
when I paste and the only way I can apply it is to re-select the ranges.
What am I missing?