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

's Computer Specifications

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.

's Computer Specifications

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.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Incorporating Cell color fill in an "if" logical function?	=?Utf-8?B?R2VvcmdlX1NreQ==?=	Microsoft Excel Worksheet Functions	42	6th May 2010 06:42 PM
How do I change the fill color of a cell using an "IF" function	=?Utf-8?B?ZG9uc2NoYXA=?=	Microsoft Excel Worksheet Functions	6	9th Mar 2010 03:48 PM
Logical Test comparison using cell color	=?Utf-8?B?Y2hhbXVrbw==?=	Microsoft Excel Misc	2	9th Nov 2005 03:09 AM
how do i get answer is 1 from CELL("color",sth) function?	=?Utf-8?B?VC5UaGluaA==?=	Microsoft Excel Misc	1	24th Jun 2005 10:07 AM
Re: How do I use Cell Fill Color as a logical test?	JE McGimpsey	Microsoft Excel Worksheet Functions	0	10th Sep 2004 02:51 PM