If formula based on text color 2

[sawedoff]

I have exhaused my resources, so I expect the answer is NO, but I'll ask anyway. I have a user who wants to write an IF statement in Excel that looks at the color of the text in a cell. Is it possible?

Sawedoff

 

[SkipVought]

Hi,

The short answer is NO.

However....

check out

Count a set of cells based on their colour faq707-6049

Skip,

_{[red]Be Advised![/red] The only distinction between a bird with one wing and a bird with two, is merely...
a difference of A Pinion!}

 

[sawedoff]

Thanks, Skip. That will definately be something I make a note of for the future, but for this particular user, anything beyond IF would become MY maintenance nightmare. So since I already told her no, I think I'll leave it there. Thanks again.

Sawedoff

 

[firefytr]

If conditionally formatted, then take a look here..

http://vbaexpress.com/kb/getarticle.php?kb_id=190

-----------
Regards,
Zack Barresse

 

[sawedoff]

Thanks Zack. You've given me another really good answer that I may use in the future. But I need to avoid VBA for this user. Thanks again.

Sawedoff

 

[firefytr]

Without VBA, your options are difficult and more difficult. Check this out..

http://www.mrexcel.com/board2/viewtopic.php?t=21312

-----------
Regards,
Zack Barresse