Welcome to Live View – Take the tour to learn more

Start Tour

‹ back to topics

There is currently 1 person viewing this thread.

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

Dealem....

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

Show More

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

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

just bet like Moneytree- and all that was once green will turn red.

Post Your Reply Text Format: Table: Smilies:

Please login to post a reply.

Wonder

Instance ID: 13539