How do I make the number(font)in the cell change to red color when the value
less than 20?

Formatconditional formatting, cell value is less than 20, click format and
select red font and click OK twice

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"Anna" wrote in message
...
How do I make the number(font)in the cell change to red color when the
value
less than 20?

Assume col B is where the numbers will be

Select col B

Click Format Conditional Formatting

Under Condition1, make the settings** as

Cell value Is | less than | 20

Click Format button Font tab Red/Bold OK
Click OK at the main dialog

Test it out by inputting some numbers in col B

**Alternatively, instead of using "Cell value Is"
you could also set it as a formula, viz.:

Formula Is | =B1<20

Click Format button Font tab Red/Bold OK
Click OK at the main dialog

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Anna" wrote in message
...
How do I make the number(font)in the cell change to red color when the
value
less than 20?

Take a look at http://www.xldynamic.com/source/xld.CF.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Anna" wrote in message
...
How do I make the number(font)in the cell change to red color when the
value
less than 20?