Sorting data according to format

  • Thread starter Thread starter Wombat
  • Start date Start date
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 :-)
 
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

Count cells according to format 2
Enabling Autofilter and Sorting in a Protected Sheet 2
Sorting several columns 1
Alternating row colour according to month 2
keep source formatting when concatenating 1
Merging Cells and Sorting 1
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Formatting cell 2

Back
Top