I have created a number of templates in Excel 2000 which have undergone
numerous changes over their lives. When opened in Excel 2007, a number of
cells are changing colour because of confitional formatting. This formatting
does not exist as far as Excel 2000 is concerned.

Is there some way in Excel 2000 that I can find cells with this hidden
formatting? Alternatively, is there a VBA method of finding all cells
apparently without conditional formatting, then deleting all conditional
formatting from these cells? It'll take an age to go through each template
manually.

--
Ian
--