Hello. I'm having a problem that has recently appeared.

I have a worksheet that has 4 conditional formats that affect a range of cells to determine what color they turn depending on what information is entered.

The formatting works just fine until the sheet is copied at which point the formatting order gets randomly changed in the newly copied sheets. This only happens if there are more than 3 conditional formats and it affects not just my sheet as other co-workers have noticed the same thing with different sheets that they use as well.

This happens if I manually copy the sheet or use VBA to copy the sheet.

I've googled the problem but have found very little as to what the problem is or if there are any solutions.

Any ideas?