Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Andy
 
Posts: n/a
Default 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.


  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Is it possible to perform a filter by format in excel.

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
  #3   Report Post  
Posted to microsoft.public.excel.misc
Andy
 
Posts: n/a
Default Is it possible to perform a filter by format in excel.

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003, It wont print in landscape format STEVE665 Excel Discussion (Misc queries) 1 July 12th 05 04:47 PM
Imported Date & Time format with calcs. managed in excel from imrp Todd F. Excel Worksheet Functions 0 July 8th 05 09:03 PM
Improve visibility of Excel AutoFilter Filter selections Cec Tarasoff Excel Worksheet Functions 0 June 22nd 05 08:56 PM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
Excel enters date as a text format Kane Excel Discussion (Misc queries) 3 March 22nd 05 09:20 PM


All times are GMT +1. The time now is 09:08 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"