Hi

I use conditional formatting a lot, and I understand how to use it.

I find, after a while, as my workbook is being modified, extended & 'improved', that some cells gain several copies of the same conditional formats, due to copying cells and formats etc etc.

It's not a major problem, I know how to solve it, but it does cause things to go wrong sometimes.

Is there of identifying such cells before they cause problems?, some sort of 'tidying' or 'optimising' procedure ?

Many thanks for any ideas. K