View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
baronmarsh baronmarsh is offline
external usenet poster
 
Posts: 1
Default 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", "")]