Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 45
Default Sorting data according to format

Hi!

Is it possible to 'autofilter' a list according to the format of the cells?
Alternatively, could I create a new list with all the relevant lines of data
(eg. only cells that are bold would be included) and none of the irrelevant
cells?

Thanks for any help :-)
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default Sorting data according to format

No.
Only by VBA, unless the formatting is (or could have been) by conditional
formatting, in which case you can filter by the condition which gives rise
to the format.
--
David Biddulph

"Wombat" wrote in message
...
Hi!

Is it possible to 'autofilter' a list according to the format of the
cells?
Alternatively, could I create a new list with all the relevant lines of
data
(eg. only cells that are bold would be included) and none of the
irrelevant
cells?

Thanks for any help :-)



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
Sorting dates in the format Jan Feb Mar Apr ... ??? Colin Gorman Excel Discussion (Misc queries) 4 July 11th 08 01:49 AM
Sorting Data and Keeping format of rows Luci Excel Discussion (Misc queries) 0 May 24th 07 06:38 AM
sorting time format Guerilla Excel Discussion (Misc queries) 1 March 30th 07 12:56 PM
Sorting data into different format.... neilcarden Excel Worksheet Functions 1 September 20th 06 11:57 AM
Sorting Columns to a set Format. samprince Excel Discussion (Misc queries) 1 June 12th 06 02:25 PM


All times are GMT +1. The time now is 04:17 PM.

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

About Us

"It's about Microsoft Excel"