Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
can you use a text colour as a formating condition?
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
can you use a text colour as a formating condition?
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
can you use a text colour as a formating condition?
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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
can you use a text colour as a formating condition?
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) "Roger Govier" wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In Excel, colour formatting (text and background) reverts to blk | Excel Discussion (Misc queries) | |||
text colour not kept | Excel Discussion (Misc queries) | |||
weird no more cell fill and text colour | Excel Discussion (Misc queries) | |||
Text Colour In Linked Cell | Excel Discussion (Misc queries) | |||
Text Formating | Excel Worksheet Functions |