Not built in, but you can find it here
http://www.cpearson.com/excel/colors.htm
=IF(cellcolorindex(A1)=3,"stop","go")
--
Regards,
Peo Sjoblom
"Ken Peterson" wrote in message
...
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