Sorting data according to format

W

Wombat

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

David Biddulph

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Formating bolded text exclusively. 0
Merging from an Excel file with graphics 1
Enabling Autofilter and Sorting in a Protected Sheet 2
Sorting several columns 1
Formatting data from excel sheet 2
Merging Cells and Sorting 2
Sorting while protected - this question may not have been covered. 1

Top