Prevent conditional formatting from being override

  • Thread starter Thread starter crapit
  • Start date Start date
C

crapit

E.g When I copy a cell (sheetname = "Main" with normal data + comment) to
another
worksheet cell (sheetname = "test") with conditional formatting , the
conditional formatting is gone.

How to prevent it? Paste value only?
 
Yep - If you can't protect the cell then you need to use edit / paste
special / values or formulas etc

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------­------------------------------­----------------
 
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

error in highlighting duplicate values in excel 1
Copying Row Code Doesn't Copy Conditional Formating 10
Conditional Formatting 1
Conditional formatting if three conditions are true 1
copy conditional formatting using built in feature? 1
Conditional Formatting 1
Conditional formatting being copied 4
Conditional formatting based on formula cell 6

Back
Top