Find "invisible" conditional formatting
in [Programming]
|
Prev: VBA - how do I pass info from dropdown list to a string??
Next: VB converting UK to US dates, randomly, ignores cdate func!
From: IanC on 28 May 2010 06:05 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 --
From: Bob Phillips on 28 May 2010 09:06 Why would it not show in Excel 2000? Could you select all cells and just delete any and all conditions? -- HTH Bob "IanC" <me(a)me.com> wrote in message news:FzMLn.4937$jh6.3489(a)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 > -- > >
From: IanC on 28 May 2010 09:37 Hi Bob I have no idea why it doesn't show in 2000. It's very peculiar. Over the years the templates have undergone continuous modifications, including many changes to conditional formatting (conditions deleted, others added etc). I can't simply select all cells and delete the conditional formatting as there are many cells with conditional formatting that I wish to keep. Unfortunately, I don't have access to Excel 2007 so I can't open the templates in that and check visually which cells are affected. What I need is some way to determine what cells Excel 2000 *thinks" are empty of conditional formatting, then to delete all conditions from these cells. Oddly, that seems to cure it, even though Excel 2000 showed the cells as having no conditions set. Any thoughts? -- Ian -- "Bob Phillips" <bob.phillips(a)somewhere.com> wrote in message news:6JidnSNqZrR_ImLWnZ2dnUVZ8mOdnZ2d(a)pipex.net... > Why would it not show in Excel 2000? > > Could you select all cells and just delete any and all conditions? > > -- > > HTH > > Bob > > "IanC" <me(a)me.com> wrote in message news:FzMLn.4937$jh6.3489(a)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 >> -- >> >> > >
From: Bob Phillips on 28 May 2010 18:33
Can you post the workbook somewhere and point me at some of these 'hidden' formats? I have 2000 and 2007, I would like to take a look at it. -- HTH Bob "IanC" <me(a)me.com> wrote in message news:PGPLn.478$bb1.313(a)hurricane... > Hi Bob > > I have no idea why it doesn't show in 2000. It's very peculiar. Over the > years the templates have undergone continuous modifications, including > many changes to conditional formatting (conditions deleted, others added > etc). > > I can't simply select all cells and delete the conditional formatting as > there are many cells with conditional formatting that I wish to keep. > Unfortunately, I don't have access to Excel 2007 so I can't open the > templates in that and check visually which cells are affected. > > What I need is some way to determine what cells Excel 2000 *thinks" are > empty of conditional formatting, then to delete all conditions from these > cells. Oddly, that seems to cure it, even though Excel 2000 showed the > cells as having no conditions set. > > Any thoughts? > > -- > Ian > -- > > "Bob Phillips" <bob.phillips(a)somewhere.com> wrote in message > news:6JidnSNqZrR_ImLWnZ2dnUVZ8mOdnZ2d(a)pipex.net... >> Why would it not show in Excel 2000? >> >> Could you select all cells and just delete any and all conditions? >> >> -- >> >> HTH >> >> Bob >> >> "IanC" <me(a)me.com> wrote in message news:FzMLn.4937$jh6.3489(a)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 >>> -- >>> >>> >> >> > > |