I'm presently deleting about 1,800 conditional formats one at a time. Click, wait, gone. Click, wait gone.

My only theory (ha) is that I put the conditional formatting for one range of cells, with a formula that applies to another worksheet. The other worksheet I then filtered much of the data in/out resulting in many, many many different conditional formats.

Suggestions for the eejit are welcome :-)