You have conditional formatting rules in Excel 2016 and all of a sudden they are duplicated all over the place and super messy. This fixes it.
email@example.com wrote this about 5 years ago and it was last updated about 5 years ago.
I've been doing conditional formatting in Excel for ages. Back before the 2016 days. It always annoyed me that rules would become duplicated. For example, I'd set rules on a range of cells like A1:D4 but if I inserted a column then my rules would get duplicated and split into two rules around the location where I entered the new row.
This is annoying and I have finally decided to fix it. Wasn't very easy to find so below is the link to what I found as well as a copy of the steps to fix this. In case the site ever goes down and I need to refer back to those steps.