Excel: Color a cell if a cell in another Column in the same row has a word

Monday Tuesday Wednesday Thursday Friday
Me Host Host Co-Host
You Co-Host Host Host Co-Host
them Co-Host Co-host Host
I would like Me, You, Them colored a certain color if they are host or co-host..Monday being one color, Tuesday being another one, and so on an so forth. Is it possible? if needed i can give more detail.

This question generated 21 answers. To proceed to the answers, click here.

This thread is current as of June 28, 2014.

For more resources for Microsoft Excel