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?
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 :-)
------------------------------*------------------------------*----------------
"crapit" <[email protected]> wrote in message
news:[email protected]...
> 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?
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks