Conditional formatting not updating
The following file formats have feature and formatting differences as described.
This file format (.prn) saves only the text and values as they are displayed in cells of the active worksheet.
Now, it has two rules, instead of one, after one copy and paste within the table.
UPDATE - March 2017: I've found a quicker way to fix the problem, as you can see in this video.
That should give you some idea of how long that list was.
Every time that I copied and pasted within the conditional formatting range, it created another rule for the worksheet. Let's take a look at the smaller example, where I just copied and pasted the Region and Product headings.
But this week I ran into a conditional formatting crisis, and had to start from scratch.
You can see the tiny scroll box at the bottom right in the screen shot below.
Earlier this year, I posted a tip for separating dates in a list, by using a red border at the start of a date change.