A
Anna
How do I make the number(font)in the cell change to red color when the value
less than 20?
less than 20?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
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)
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)
M
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
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
B
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)
--
HTH
RP
(remove nothere from the email address if mailing direct)