Formula to pull data from one sheet to another if X = Yellow

G

Guest

Can I pull data from one sheet to another (summary) because of color?

I have conditional formating that shows me on one sheet what groups are
late, now on the summary sheet I want to pull a result list of just the group
names if the group name cell has turned yellow.

Can this be done and how?

Thanks in advance
 
G

Guest

Thanks, looks like I will have to change my conditional formatting useage as
these options do not recognize colors used by conditional formatting
 

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

Similar Threads

Copy Data from 1 Sheet to Another 3
Referencing a named range on another sheet 4
Pull Information from one sheet to another 1
Summing multiple validated sheets into a summary sheet 3
Referencing formula using Indirect 4
Copy Data from One sheet to Different Sheets 1
item # in one sheet want to pull data that matches from other tab 3
Pull a value from another worksheet 2

Top