| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookup / pull data from 1 sheet to another | Excel Discussion (Misc queries) | |||
| Pull data from multiple sheet | Excel Worksheet Functions | |||
| formula for if Cell c1 is yellow shaded cell d1 should be yellow | Excel Discussion (Misc queries) | |||
| How do I pull certain data from several worksheets in one sheet? | Excel Worksheet Functions | |||
| pull data from sheet two, then fill in the data to sheet one (part | Excel Worksheet Functions | |||
Hybrid Mode
