can you use a text colour as a formating condition?

[Guest]

Does anybody know if you can use a colour in excell as a conditioning varible
I.E if text is red then dont include in total.
or if text is green then include.
If so do I do this? £5.00 reward for anybody who knows!

 

[Roger Govier]

Hi

Take a look at Bob Phillip's solutions at
http://xldynamic.com/source/xld.ColourCounter.html

 

[Bob Phillips]

Does that mean you get the fiver?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Roger Govier]

Of course not, Bob!!!!
I can just see you enjoying your 2 pints of Wadsworth 6X<bg>
I'm amazed I beat you to the draw!!

 

[Bob Phillips]

You'll have to come down and drink one (or two, or three ) with mw.

As you are from the same stock as were my forefathers, I am amazed that you
used Phillip's, not Phillips'.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)