I have a several large Excel tables that I am managing for my current project. Whenever a metric or value in the table changes, I indicate the change by changing the background color of the cell for the first version that it appears in.
When I go in to create a new version, I normally use the Find&Replace functionality to change all the colored cells back to their default "No-Background" setting.
Lately I've started adding the middle shade of purple to some of the cells (Purple, Accent 4, Lighter 40%) and have noticed that when I come back later on to clear those cells, I can't find them with the Find&Replace tool. They are still clearly visible and the "Filter by Cell Color" filter option will pick them up, but the Search function skips right over them. What makes it even more strange is that it's just this one color, I can still find every other color just fine. Also, if I change the background of one of these purple cells and then change it right back I can then Find&Replace like always.