View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Neall Neall is offline
external usenet poster
 
Posts: 95
Default 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