Can I create an "IF" function using cell color as a logical test?
 

I would like to create an IF funcation using the color of a cell. For example:

If B2=Red, Yes, No

Does anyone know if this is possible or if there is another funcation that
is similiar and will work.

Can I create an "IF" function using cell color as a logical test?
 

http://www.cpearson.com/excel/colors.aspx

Chip Pearson has this solution on his web page.

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"JessLynn" escreveu:

I would like to create an IF funcation using the color of a cell. For example:

If B2=Red, Yes, No

Does anyone know if this is possible or if there is another funcation that
is similiar and will work.