View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default 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.