Change the Font Color

[Anna]

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

 

[Peo Sjoblom]

Format>conditional 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)

 

[Max]

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

 

[Bob Phillips]

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

--

HTH

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