Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a function like Vlookup that works with cell colors?
I have a spreadsheet that has Name, Task, Time....
Because the same person might do multiple tasks, the cells are color coded. So i have....ex. John and his cell is yellow. Among his taks are sweeping, dusting, cleaning windows they are also highlighted in yellow. What i want to do in a formula is to type John's name and for his tasks to be looked up by the color so I can have the following... John Sweeping Dusting Cleaning windows is this possible with any of the formulas in excel? I really need the help because John needs to get going with his taks :) Thank you for your help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a function like Vlookup that works with cell colors?
Formulas generally do not affect the formatting of a cell - instead,
they return results of some calculation. You would need some VBA to do what you describe. Hope this helps. Pete On Jan 30, 10:34*pm, Jose wrote: I have a spreadsheet that has Name, Task, Time.... Because the same person might do multiple tasks, the cells are color coded. * So i have....ex. *John and his cell is yellow. *Among his taks are sweeping, dusting, cleaning windows they are also highlighted in yellow. What i want to do in a formula is to type John's name and for his tasks to be looked up by the color *so I can have the following... John *Sweeping * * * * *Dusting * * * * *Cleaning windows is this possible with any of the formulas in excel? *I really need the help because John needs to get going with his taks :) Thank you for your help. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a function like Vlookup that works with cell colors?
Show us a sample of your data layout and the results you want. As stated,
I'm not sure why you are looking for a color. Are you saying that on a row beside John all the tasks are listed and those that he does are color coded? And that you want a vlookup to return the yellow cell contents? Why not just list the tasks that John does? Then a vlookup would work easily. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Jose" wrote: I have a spreadsheet that has Name, Task, Time.... Because the same person might do multiple tasks, the cells are color coded. So i have....ex. John and his cell is yellow. Among his taks are sweeping, dusting, cleaning windows they are also highlighted in yellow. What i want to do in a formula is to type John's name and for his tasks to be looked up by the color so I can have the following... John Sweeping Dusting Cleaning windows is this possible with any of the formulas in excel? I really need the help because John needs to get going with his taks :) Thank you for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
range label works in VLOOKUP except if refenced in another cell | Excel Worksheet Functions | |||
Function works in one cell but not another | Excel Worksheet Functions | |||
referencing active cell works in a sub but not in a custom function | Excel Worksheet Functions | |||
referencing active cell works in a sub but not in a custom function | Excel Worksheet Functions | |||
Offset Function works in cell, not in named range | Excel Worksheet Functions |