Excel custom formatting and the hazards of cut and paste

Was assembling a project tracking spreadsheet in Excel with plenty of custom formatting rules to categorize and tracks those things that need to be categorized or tracked. It is not something I had done in a while, since I am used to being in Mac shops, but here Numbers was not an option.

So I set up my rules for each column and then started inserting new rows and cutting and pasting things into them all over the place.

Went to go change one of my rules for a column and discovered it now had not the original six custom formatting rules, but something closer to sixty. So what happened?

Continue reading