How to filter color changed cells

[mvenkatesan45]

Hi guys,

I am writing a macro to find the special char in the Balance
column(ie. only Numeric format)
Its finds and changed cells interior color on the particular column,
whiever cells contained specl.
But my question is HOW TO FILTER THE CHANGED COLOR CELLS?
Is filter possible to changed color cells?

Plz help

Advanced thanks
Venky

 

[mvenkatesan45]

Hi guys,

I am writing a macro to find the special char in the Balance
column(ie. only Numeric format)
Its finds and changed cells interior color on the particular column,
whiever cells contained specl.
But my question is HOW TO FILTER THE CHANGED COLOR CELLS?
Is filter possible to changed color cells?

Plz help

Advanced thanks
Venky

I can used Easy filter. but can't set the shortcut key. How to set
shortcut?

Venky

 

[Peo Sjoblom]

Unless you want to use VBA you can try 2 ways, either get Excel 2007, there
you can filter for colour. Or use the criteria that made you change the
colour in the first place and use that when you filter