how to filter out highlighted cells
 

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

how to filter out highlighted cells
 

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)

"grlong" wrote in message
...
I have several rows of highlighted data, I would like to filter and print
only the highlighted rows

how to filter out highlighted cells
 

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

"Bob Phillips" wrote:

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)

"grlong" wrote in message
...
I have several rows of highlighted data, I would like to filter and print
only the highlighted rows

how to filter out highlighted cells
 

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

"grlong" wrote:

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

"Bob Phillips" wrote:

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)

"grlong" wrote in message
...
I have several rows of highlighted data, I would like to filter and print
only the highlighted rows

how to filter out highlighted cells
 

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

On Aug 1, 1:02 am, mkirkwag
wrote:
Any methods that don't involve installing anything? Most of us working in
major corporations aren't allowed to install.



"grlong" wrote:
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

"Bob Phillips" wrote:

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"grlong" wrote in message
...
I have several rows of highlighted data, I would like to filter and print
only the highlighted rows- Hide quoted text -

- Show quoted text -