787 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)Jan-Rienk Hemminga commented
@Tony Although you might have a point, I do not think this is a place to raise this issue. This is where we’re trying to get conditional formatting to work with named ranges. This is something that data validation already does. (On a side note, if table names don’t work for data validation, I think you can get it to work by using a name that refers to the table.).
@Microsoft: So what’s the status on this? This has been the number one suggestion in formatting for a couple of years now. And it feels a lot like we’re shouting to deaf ears.Jan-Rienk Hemminga commented
So, this is the number one issue in formatting, and number 12 over-all... We need some love over here.Jan-Rienk Hemminga supported this idea ·