Text box Text color

K

KAnoe

I have a text box [DI To MAX] that has a number value in it. I would like the
number text to be green if it is a negitive number and red if it is not.

Any help would be great.
 
K

KAnoe

How Please?

Rick B said:
Use conditional formatting.


KAnoe said:
I have a text box [DI To MAX] that has a number value in it. I would like the
number text to be green if it is a negitive number and red if it is not.

Any help would be great.
Click to expand...
Click to expand...
 
F

fredg

I have a text box [DI To MAX] that has a number value in it. I would like the
number text to be green if it is a negitive number and red if it is not.

Any help would be great.
Click to expand...

All you need do is set the Format property of the control to:
# [Red];-# [Green];0 [What color for zero]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Program buttons to create a word document 0
Link a text box based on drop down box with four options MS Word 365 0
Change text box background color depending on value in Label Reports 0
Word OLE to check spelling in text box 1
Macro to select and delete levels of a document 2
Finding the proper style field and the numbered paragraph value within the style 0
MS Word normal.dot cannot be fixed 'text box' appears each time 4

Top