Excellent, thank you.

"Peo Sjoblom" wrote:

> 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" <KenPeterson@discussions.microsoft.com> wrote in message
> news:B394430C-1F8B-4FEC-993D-A1D1531410E5@microsoft.com...
> > 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
>
>
>