Is it possible to perform a filter by format in excel.

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.

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

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
>