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

N

Neall

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
 
N

Neall

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