Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / September 2004

Tip: Looking for answers? Try searching our database.

How to: text color depend on value

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
bobsmith58d - 20 Sep 2004 04:25 GMT
Anyone know how to make the text change colors, depending on what valu
certain data is? I'm sure it's easy...
BenjieLop - 20 Sep 2004 04:32 GMT
bobsmith58d Wrote:
> Anyone know how to make the text change colors, depending on what valu
> certain data is? I'm sure it's easy....

Go to Format/Cells/Custom and inside the "Type" box,  choose the forma
that will suit your application.

Hope this will help you

--
BenjieLo
Max - 20 Sep 2004 05:10 GMT
Perhaps conditional formatting would be a better option <g>

This example assumes you want to conditionally format
an adjacent cell if a certain trigger condition
is activated in another "target" cell

Assume you want to conditionally format B1 to display
the font in red & bolded, if the number in A1 exceeds 10
(A1 will be the "target" cell here)

In B1, you might typed have a text-phrase
relevant to the number in A1, e.g.: "Alert!"

Try this:

Select B1

Click Format > Conditional Formatting

Under Condition 1, make the settings:
Formula Is| =$A$1>10
Click Format button > Font tab > red/bold > OK

Click OK at the main dialog

The text-phrase in B1 will then appear
with font in red & bolded
whenever the trigger condition is activated
i.e. A1 > 10

(Test this out by inputting some numbers in A1)
Signature

--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik <at>yahoo<dot>com
----

>
> bobsmith58d Wrote:
[quoted text clipped - 12 lines]
> BenjieLop's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=11019
> View this thread: http://www.excelforum.com/showthread.php?threadid=261487
Debra Dalgleish - 23 Sep 2004 22:58 GMT
And for some examples of specifying colour in number formats, see Jon
Peltier's web site:

  http://peltiertech.com/Excel/NumberFormats.html

> bobsmith58d Wrote:
>
[quoted text clipped - 3 lines]
> Go to Format/Cells/Custom and inside the "Type" box,  choose the format
> that will suit your application.

Signature

Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.