Assume cell with name in it is A1, cell you want colored is A2.

Select A2, go to Format-Conditional Format.
First box change to "Formula is"

for the formula, input:
=A1="ParticularName"
Choose whatever format you want.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"mykcap" wrote:

This is probably very simple to do but I can't seem to figure it out. I would
like to fill a cell with a color if the value of another cell has a
particular name in it.