688 votes195 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)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 ·