View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default =If() results based on cell color?

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