how to filter out highlighted cells

[Guest]

I have several rows of highlighted data, I would like to filter and print
only the highlighted rows

 

[Bob Phillips]

If you mean highlighted by colour or conditional formatting, see Ron de
Bruin's EasyFilter add-in at http://www.rondebruin.nl/easyfilter.htm

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Guest]

Oh my goodness! I have been trying to do this without success
and from your response it took me less than 5 minutes
Thank you

 

[Guest]

Any methods that don't involve installing anything? Most of us working in
major corporations aren't allowed to install.

 

[Pete_UK]

If the highlighting comes from conditional formatting then you can
apply the same CF formula in a helper column to return TRUE or FALSE,
and then apply the filter to this column. If the colouring is done
manually, and you are not allowed a macro to read the colour, then you
will have to manually enter a code (Y/N ?) in the helper column and
then filter on this.

Hope this helps.

Pete