finding and extracting values from a specific colored cell

A

alowicious

Hello,

I need some help. I am trying to extract values only from cells tha
are a specific color (in my instance, yellow) is there a function tha
will allow me to do this?

Thanks in advance for your help!

Alowiciou
 
N

NickMinUK

You can select a cell conditionally based on formatting, by using a
add-in from ASAP Utilities (www.asap-utilities.com) which is freeware
Use "Cell Select", "Conditional Cell Select", "Based on Formatting"
This will select all cells with the same format as that defined (yello
in your case). You can then copy/paste the data from these selecte
cells. Nic
 
A

alowicious

Thanks, I was just looking at that site.

What I am trying to do is this.

A B C D
E F
1 6/1/04 6/2/04 6/3/04 6/4/04
6/5/04
2 oven frank frank steve frank
frank
3 microwave bill bill bill
cecil bill
4 blender mary mary mary mary
mary


in this instance steve and cecil would have yellow backgrounds because
they are not usually associated with the appliances.

I want to be able to pull the names from the yellow cells along with
the associated dates and appliances and have them listed elsewhere in
the workbook.

?

Alowicious
 
N

NickMinUK

What is the method of changing cell colour - conditional format? If so
based on what condition
 

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

Top