Share via

Worksheet wide conditional formatting breaks when rows/columns add/moved

Anonymous
2018-03-02T22:36:26+00:00

I have a large spreadsheet I work in daily with lots of conditional formatting in it. Most of the conditional formatting affects an entire column or row, a few cover the whole table.

How do I stop these broad formatting settings from BREAKING any time I add/remove/move rows? It is dumb and SUPER time consuming to constantly be cleaning up my conditional formatting.

Any suggestions?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

7 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-03-06T13:47:41+00:00

    Hi Neha,

    Yes, I looked at the "solution" and it is simply a work around. I have my own in place.

    It doesn't answer the question of why Excel breaks worksheet/table wide conditional formatting while addng/removing/moving within the affected area.

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments
  2. Anonymous
    2018-03-07T09:06:20+00:00

    Hi MuseumHannah,

    We will need the information requested in my original post, this will help us identify the problem.

    Thanks,

    Neha

    Was this answer helpful?

    0 comments
  3. Anonymous
    2018-03-06T01:52:36+00:00

    Hi MuseumHannah,

    Did you check the above reply? Please update us if you still need help.

    Regards,

    Neha

    Was this answer helpful?

    0 comments
  4. Anonymous
    2018-03-03T07:41:53+00:00

    Hi MuseumHannah,

    Please follow the suggestion from the article provided by Norman.

    If the issue persists, we would like to confirm the following information:

    1. Could you please provide the screenshot of Office 2016 Product Information? To get this screenshot, open Excel 2016 on your system, click File>Account, capture the screenshot of all the information mentioned under Product Information. (Note*: please remove any sensitive information from the screenshot such as email address and full name)*
    2. Please provide a simple example with detail steps to reproduce the issue. Also, provide some related screenshot to understand the issue better.

    Thanks,

    Neha

    Was this answer helpful?

    0 comments
  5. Anonymous
    2018-03-02T23:21:53+00:00

    Hi MuseumHannah,

    I have a large spreadsheet I work in daily with lots of conditional formatting in it. Most of the conditional formatting affects an entire column or row, a few cover the whole table.

    How do I stop these broad formatting settings from BREAKING any time I add/remove/move rows? It is dumb and SUPER time consuming to constantly be cleaning up my conditional formatting.

    Any suggestions?

    See Debra Dalgleish's comments and suggestions:

    Excel 2010 Conditional Formatting Nightmare

    ===

    Regards,

    Norman

    Was this answer helpful?

    0 comments