ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Sorting data according to format (https://www.excelbanter.com/excel-discussion-misc-queries/246795-sorting-data-according-format.html)

Wombat

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 :-)

David Biddulph[_2_]

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 :-)





All times are GMT +1. The time now is 01:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com