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

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
--
Neall

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

Have a look he-

http://www.cpearson.com/excel/colors.htm

Mike

"Neall" wrote:

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
--
Neall

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

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


"Mike H" wrote:

Have a look he-

http://www.cpearson.com/excel/colors.htm

Mike

"Neall" wrote:

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
--
Neall

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

EasyFilter can do it for you
http://www.rondebruin.nl/easyfilter.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Neall" wrote in message ...
Thanks, looks like I will have to change my conditional formatting useage as
these options do not recognize colors used by conditional formatting
--
Neall


"Mike H" wrote:

Have a look he-

http://www.cpearson.com/excel/colors.htm

Mike

"Neall" wrote:

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
--
Neall