Feedback by UserVoice

Peter Collins

My feedback

  1. 1,037 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for supporting this feature. We won’t be able to offer this in the near future, but we understand that it would be a nice improvement. Even though it seems like a straightforward idea, it is quite complex. Old versions of Excel will not support the new behavior, so there would need to be some hybrid approach that will be suitable for old and new versions. Also, named ranges can be dynamic, meaning that the range might change and conditional formatting rules would have to be adjusted when the workbook is calculated. There are lots of cases to consider and deal with properly.

    We’ll continue tracking votes for this suggestion.

    An error occurred while saving the comment
    Peter Collins commented  · 

    @NC the problem is that excel converts named ranges into references that aren't dynamic. So if the size of the namerange changes, the CF doesn't update.

    Peter Collins supported this idea  · 
    An error occurred while saving the comment
    Peter Collins commented  · 

    Can we just not copy conditional formating over to tables. When is it ever needed to copy conditional formating to another table? Conditional formatting should only ever apply to the table it's applied to and not whatever table data is being pasted to. Copying conditional formating should be done from the conditional formating pane itself and into the conditional formating pane, i.e. I can copy paste formating rules.

    Stopping conditional formatting from being copied from cells would be a huge improvement in of itself.

    An error occurred while saving the comment
    Peter Collins commented  · 

    @roy

    What if, if you apply it to a named range... it applies to a named range?

    An error occurred while saving the comment
    Peter Collins commented  · 

    Microsoft probably need to redesign how Tables work entirely. Or just make a new Tables program and we'll use that instead

  2. 148 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Peter Collins supported this idea  · 
  3. 71 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Peter Collins supported this idea  · 
  4. 2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Peter Collins shared this idea  · 

Feedback and Knowledge Base