Feedback by UserVoice

kevin

My feedback

  1. 694 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    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.

    Thanks,
    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 me

    kevin 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?

Feedback and Knowledge Base