Filtering Data?

[Louise]

Hi all

Is it possible to filter data by the colour of cells? I have a large
worksheet and in Column A, some of the cells are shaded in red. I want to
filter the worksheet so I can only see those records that are not shaded in
red.

Don't know what function would be best for this?

Thank you for any help.

Regards.

Louise

 

[Frank Kabel]

Hi
you need VBA for this. see:
http://cpearson.com/excel/SortByColor.htm

 

[Louise]

Thanks very much, Frank. I didn't realise it would be so complicated!!

Louise