New Posts For Thread: Excel question: can i make the text appear a diff colour for diff values?https://community.betfair.com/chit_chat/go/thread/view/94038/23423438/excel-question-can-i-make-the-text-appear-a-diff-colour-for-diff-valuesthe text or a box to change colour i don't mind.cheers.just bet like Moneytree- and all that was once green will turn red.https://community.betfair.com/chit_chat/go/thread/view/94038/23423438/excel-question-can-i-make-the-text-appear-a-diff-colour-for-diff-values?post_id=417788718#417788718just bet like Moneytree- and all that was once green will turn red.Thu, 17 Dec 2009 11:56:46 -0600Format Conditional FormattingIf in doubt, go to videojug!http://www.videojug.com/webvideo/how-to-use-conditional-formatting-in-microsoft-excelhttps://community.betfair.com/chit_chat/go/thread/view/94038/23423438/excel-question-can-i-make-the-text-appear-a-diff-colour-for-diff-values?post_id=417788714#417788714Format Conditional FormattingIf in doubt, go to videojug!http://www.videojug.com/webvideo/how-to-use-conditional-formatting-in-microsoft-excelThu, 17 Dec 2009 11:56:15 -0600excellent, i have done it and that is exactly what i want.the text to appear red if ="no" and usual if not.ty sir...https://community.betfair.com/chit_chat/go/thread/view/94038/23423438/excel-question-can-i-make-the-text-appear-a-diff-colour-for-diff-values?post_id=417788710#417788710excellent, i have done it and that is exactly what i want.the text to appear red if ="no" and usual if not.ty sir...Thu, 17 Dec 2009 11:56:08 -0600it's quite straightforward iirc.if stuck put a shout out for Fishy on GB. He's a guru!https://community.betfair.com/chit_chat/go/thread/view/94038/23423438/excel-question-can-i-make-the-text-appear-a-diff-colour-for-diff-values?post_id=417788674#417788674it's quite straightforward iirc.if stuck put a shout out for Fishy on GB. He's a guru!Thu, 17 Dec 2009 11:51:25 -0600plenty in the help section about that so ill have a browse, thanks...https://community.betfair.com/chit_chat/go/thread/view/94038/23423438/excel-question-can-i-make-the-text-appear-a-diff-colour-for-diff-values?post_id=417788670#417788670plenty in the help section about that so ill have a browse, thanks...Thu, 17 Dec 2009 11:48:04 -0600conditional formattinghttps://community.betfair.com/chit_chat/go/thread/view/94038/23423438/excel-question-can-i-make-the-text-appear-a-diff-colour-for-diff-values?post_id=417788662#417788662conditional formattingThu, 17 Dec 2009 11:46:18 -0600the text or a box to change colour i don't mind.cheers.https://community.betfair.com/chit_chat/go/thread/view/94038/23423438/excel-question-can-i-make-the-text-appear-a-diff-colour-for-diff-values?post_id=417788646#417788646the text or a box to change colour i don't mind.cheers.Thu, 17 Dec 2009 11:41:09 -0600