Feedback by UserVoice

Anonymous

My feedback

  1. 72 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    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. Ken

    Anonymous supported this idea  · 
    Anonymous commented  · 

    This problem seems to have been around for several years and its well overdue for a fix.

Feedback and Knowledge Base