Feedback by UserVoice

Christopher Tindall

My feedback

  1. 688 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks to Graham for starting this conversation. If you would also like Excel to maintain named range references and structured table references in the “applies to” field for Conditional Formatting rules, please add your comments and vote this one up. We will prioritize accordingly.

    Thanks,
    Steve (MS Excel)

    Christopher Tindall commented  · 

    Futski... I fix proposed by Graham in the initial solution is clear. We need to be able to link conditional formatting ranges to previously defined 'named ranges'. These conditional formatting ranges would then be unaffected by modifications to cells, rows, and columns.

    Implementing this functionality is not very difficult from a programming standpoint. This is why we are all stupefied that this has not yet been implemented.

    Christopher Tindall supported this idea  · 

Feedback and Knowledge Base