Sorting by cell or text format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know of a way to sort a list by the cell
format or by the text format? I have a very long list
where the 'good' cells have been colored in yellow. Now i
want to delete the 'bad' cells.

i know that if i create an extra column and use those
cells to indicate 'good' vs. 'bad', then sort by that
column, that works as well but i was hoping that there was
someway to do this without that step...

thanks.
 
Don't know of any way to sort by format. You can sort alphabetically for
text. If there is any way you can code the cells--say, by adding an extra
column or row with "0" for bad cells and "1" for good ones, you could then
sort by that column or row to group all the bad and all the good cells
together. After you delete the bad cells, you could then also delete the
column or row with the 1s and 0s.
 
Back
Top