Select cell you want format in. Format - Conditional format.
Change first box to "formula is"
Input:
=A1="Frame"
Choose a light green pattern format.
--
Best Regards,

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


"Rich" wrote:

I know this has been answered many times but i can't put my hands on it right
now. How do I color a cell a certain color (codes?) based on the contents of
another cell. For example, if A1="Frame", then I want the cell to be light
green, if not cell remains clear of color.

Thanks,