Why not do it the other way around.

Enter "caution" in the cell and have the cell Conditionally Formatted to turn
yellow when the cell is "caution".


Gord Dibben MS Excel MVP

On Fri, 7 Mar 2008 07:52:01 -0800, baronmarsh
wrote:

I want to write a function that will enter text in a cell if a different cell
has yellow fill color.

Like this:

if cell A1 is yellow then put the text "caution" in this cell that has
the formula in it [=if(A1=yellow,"caution", "")]