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

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

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