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.