Find "invisible" conditional formatting
Why would it not show in Excel 2000?
Could you select all cells and just delete any and all conditions?
--
HTH
Bob
"IanC" wrote in message news:FzMLn.4937$jh6.3489@hurricane...
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
--
|