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