The answer, then, is to tell users not to do a standard copy and paste. This means the target cells will have the formatting of the source cells, not the formatting of the target cells (including any conditional formatting that may have been in the target cells). A standard copy and paste (or a drag and drop edit) copies everything, including formatting. This happens because conditional formatting is considered just that-formatting. He wonders about the best way to prevent this from happening. However, the conditional formatting keeps getting messed up when users copy and paste information or when they use drag and drop to edit the worksheet. ![]() Kees has a worksheet that uses conditional formatting extensively.
0 Comments
Leave a Reply. |