There is a solution at
http://www.xldynamic.com/source/xld.ColourCounter.html

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"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