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