How to filter on highlights?

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

Guest

I have a spreadsheet with a bunch of data and they do not really have a
relationship so I can't use the filter function.

How can I filter only the highlights?

Cynthia
 
Maybe you can use a cell in the same row but a different column to indicate if
this row should be highlighted. Then you could filter on that.

Alternatively, xl2007 allows you to filter on color (IIRC).

And before xl2007, Ron de Bruin's EasyFilter addin allows you to filter on
color.

Ron de Bruin's EasyFilter addin:
http://www.rondebruin.nl/easyfilter.htm
 
Back
Top