Conditional Formatting - new data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Edit>PasteSpecial>Values instead of paste

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formatting on a dynamic range - workaround 1
Excel Conditional Formatting Removal 7
conditional formatting update issue 5
Conditional Formatting 3
Excel VBA 1
Conditional Formatting 4
Conditional Format question 1
Excel Named Ranges and Conditional Format 3

Back
Top