can you use a text colour as a formating condition?

J

Johnyfartpants

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!
 
B

Bob Phillips

Does that mean you get the fiver?

--
HTH

Bob Phillips

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

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!!
 
B

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)
 
Top