Conditional Formatting: This Worksheet vs Current Selection

[hockeman52]

My Worksheet has ~50 rules for conditional formatting. From time to time, some of these rules get moved in priority to be applied, or even deleted entirely, and I am not sure why. Sometimes rules get added automatically that I do not want (for example, in certain columns, if a cell is empty, I want the background color to turn black...when the cell becomes empty, that cell, and multiple other cells in the same row turn black...when I look at the conditional formatting, new rules have been added that turn said cells black). Am I accidentally hitting a key stroke, not entering my rules properly, etc.?

All the rules highlight entire rows a specific color or change the background and/or font color of cells in certain columns. I will add a dummy excel file if it is helpful.

Thank you!

[FDibbins]

Not sure if they foxed this in 2010, but in 2007 CF would start adding extra rules if you copied data from 1 cell (with CF) to another cell (with the same CF) - extra rules being added/duplicated etc. I would imagine CF would be particulary sensitive to this if you have that many rules.