Conditional Formatting changing rules

Question

I am using Excel 2010.&nbsp;When I start a new sheet for the year, this is what my Conditional Formatting Rules look like:Example 1By the end of the year, this is what my Conditional Formatting looks like:Example 2Why is this happening?

jwr1138 · Answer

Are you doing some copy/cut/pasting on the sheet?

enough_to_be_dangerous · Answer

Sometimes I do end up cutting rows or inserting rows.

jwr1138 · Answer

That'd do it. I don't have a good answer for you as to how to keep it clean if you need to cut and insert rows but I believe that answers the why.&nbsp;

enough_to_be_dangerous · Answer

This is from my budget spreadsheet. I have a sheet set up in the workbook that I keep with the basic formatting and information so usually it doesn't matter if the conditional formatting changes on me. Occasionally we change something to the base formatting or information during the year that makes it easier to copy the current year's sheet, clear out the information specific to that year, and make that copy my new "master" sheet. Now I at least know why it does it! Thank you.

jwr1138 · Answer

Your welcome. Wish I had an easy answer for you. It would be possible to&nbsp;set up all of your conditional formatting in a VBA macro and have the ability to reset it but I can't imagine that is worth the effort required.&nbsp;

Forum Discussion

Conditional Formatting changing rules

Share

Resources