82 votes12 comments · Excel for Windows (Desktop Application) » Editing · Flag idea as inappropriate… · Admin →Anonymous commented
I use the following as a solution. If you copy (a previous entry) and paste then you MUST use the Paste Special option of 'Merge Conditional Formatting'. Problem is, if someone forgets to do this, the fragments occurs.
I have a VBA script where I have provided both a button and short cut key to do this paste.
The VBA code is based around:
Selection.PasteSpecial Paste:=xlPasteAllMergingConditionalFormats, Operation _
:=xlNone, SkipBlanks:=False, Transpose:=False
I have some code before it to help the Copy, as well a automtically selecting the last avaiable row in my spreadsheet to do the paste - but that may not apply for you.
Good luck. KenAnonymous supported this idea ·Anonymous commented
This problem seems to have been around for several years and its well overdue for a fix.