Feedback by UserVoice

4am

My feedback

  1. 693 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)

    4am commented  · 

    While some of the issues this would solve can be solved using structured references/tables (which automatically "format paint" new rows, including conditional formats), until structured references can be used in all the places that named ranges can, it would be nice to be able to use Named Ranges in the Applies To field. Especially dynamic named ranges!

    4am supported this idea  · 

Feedback and Knowledge Base