View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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