694 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)Anonymous commented
A1:F4 is range...
=A1:F4 is a formula
you don't give name, like "sales" to a range such as B1:B4... you set the formula =B1:B4 to the name "sales"
In fact you could also set an entire matrix formula to a name, and therefore the name sales could get the formula =SUM(IF(A1:A4="North",B1:B4,"")).... could it be possible that such formula assigne to "sales" have a conditiional format? would you say this "sales" is a named RANGE?
37 votes0 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
876 votes141 comments · Excel for Windows (Desktop Application) » Tables, Sorting and Filtering · Flag idea as inappropriate… · Admin →
Thanks for logging this great suggestion, Zack, and to others for voting it up. We’ll prioritize this according to the number of votes, so if there’s more interest, please make sure to register your vote!
Lead Program Manager
46 votes7 comments · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →Anonymous commented
if you want more people to use PowerQuery, you have to help and typing functions easier. Intellisense is needed