conditional formatting
 

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", "")]

conditional formatting
 

If you have manually coloured the cell yellow, then you cannot do what
you want to do with a standard formula (you could use a user-defined
function). However, if the yellow colour is the result of conditional
formatting, then you can apply the formula for that to the cell to
return "Caution".

Hope this helps.

Pete

On Mar 7, 3:52*pm, 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", "")]

conditional formatting
 

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", "")]