772 votes213 comments · Excel for Windows (Desktop Application) » Formatting · Flag idea as inappropriate… · Admin →
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.
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 ·