![]() |
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 :-) |
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