View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier Roger Govier is offline
external usenet poster
 
Posts: 2,886
Default can you use a text colour as a formating condition?

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

--
Regards

Roger Govier


"Bob Phillips" wrote in message
...
Does that mean you get the fiver?

--
HTH

Bob Phillips

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

"Roger Govier" wrote in message
...
Hi

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

--
Regards

Roger Govier


"Johnyfartpants" wrote in
message ...
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!