=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

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

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
>
>
>

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" <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