View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ken Peterson
 
Posts: n/a
Default =If() results based on cell color?

Is it possible to write a formula to base your results on the color of a cell?

For example -- if the color of cell a1 is red, then return "stop", otherwise
"go".

I suppose in Excel it would look something like this:

=if(a1=red,"Stop","go")

It's not conditional formatting because I want an actual value to to appear
in the cell.

Thanks,
Ken