Home › Chit Chat Forum › Excel question: can i make the text appear a diff colour for diff values?

Chit Chat

Welcome to Live View – Take the tour to learn more

There is currently 1 person viewing this thread.

Excel question: can i make the text appear a diff colour for diff values?

17 Dec 09 17:41

Joined:

Date Joined: 02 Dec 02

| Topic/replies: 546 | Blogger: Dealem....'s blog

the text or a box to change colour i don't mind.
cheers.

Pause • Switch to Standard View Excel question: can i make the text...

Report Reyes • December 17, 2009 5:46 PM GMT

conditional formatting

Report Dealem.... • December 17, 2009 5:48 PM GMT

plenty in the help section about that so ill have a browse, thanks...

Report Reyes • December 17, 2009 5:51 PM GMT

it's quite straightforward iirc.

if stuck put a shout out for Fishy on GB. He's a guru!

Report Dealem.... • December 17, 2009 5:56 PM GMT

excellent, i have done it and that is exactly what i want.

the text to appear red if ="no" and usual if not.

ty sir...

Report MrNibbs • December 17, 2009 5:56 PM GMT

Format Conditional Formatting

If in doubt, go to videojug!

http://www.videojug.com/webvideo/how-to-use-conditional-formatting-in-microsoft-excel