Prevent conditional formatting from being override

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?
 
K

Ken Wright

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 :)
------------------------------­------------------------------­----------------
 
Top