How to filter colour cells of a column

[Ali-imran]

Dear All,

A B C
15 85 60
10 98 23
20 11 99
16 70 55

In column A figure 10 is coloured and figure 16 is also colured. I want to filter coloured figure. Is there any code to filter such figures.

Thanks

[Jbentley]

Hi,
Have you tried the "Filter by Colour" options available in XL2007 ?

I just recorded this usinng the 'Filter by Colour' option

Please Login or Register  to view this content.

For cell with RED background fill.

Might get you started...

[share knowledge]

Try This!

Goto Insert - Name - Define
Under "Names in the workbook" - Type "CLR"
Under "Refers to" - Type "=GET.CELL(38,INDIRECT("rc[1]",FALSE))"
Give OK

Now insert a column before Column A or wherever the data is available
Type "=CLR" in the inserted column - A1
Drag it till wherever you want

This will now return the color codes. You can filter and pick the cells you want.

Thanks