View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_4_] Bob Phillips[_4_] is offline
external usenet poster
 
Posts: 834
Default 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
--