How to filter color changed cells

  • Thread starter Thread starter mvenkatesan45
  • Start date Start date
M

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
 
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
Click to expand...

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

Venky
 
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
 
Back
Top