Thanks Dave, that's what I thought.

Andy

"Dave Peterson" wrote:

It's not built into excel.

You may want to try Ron de Bruin's addin:
http://www.rondebruin.nl/easyfilter.htm



Andy wrote:

I have inherited a few large spreadsheets that ar colour coded. I need to
know whether it is possiblr to filter the data by its formating.

--

Dave Peterson