786 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)kevin commented
About a year ago I also commented on the issues with copying data with conditional formatting into a column and the resulting "copying" and creation of small ranges with in the conditional formatting rules manager. Also the issue with not being able to apply conditional formatting to a dynamic range.
I have now found that with the data in a "table" that the conditional formatting is applied when ever I add new data (paste values only) into that table and the range shown in the rule manager has updated to include the new row, not adding another small range as previously. The "table" also acts as a dynamic range so if you create a format on the first row it is applied to every cell in that column.
I'm not sure if this solves everyone's issues but it has helped mekevin supported this idea ·kevin commented
I require this for a dynamic range of value that increase as I add rows of data. I have the ranges named but cant use this function. Is there a problem with being able to program this functionality?