Archive of Mr Excel Message Board

Back to Forms in Excel VBA archive index
Back to archive home

Changing the font color if a number falls below a certain number

Posted by Sandra Riordan on January 13, 2002 5:18 PM

Is there a formula or function I can use to have the font color change to red if a number in a column of numbers falls below a particular number.

Re: Changing the font color if a number falls below a certain number

Posted by Aladin Akyurek on January 13, 2002 5:39 PM

Sandra --

You could use Conditional Formatting for this.

Select the cells of interest;
Activate Format|Conditional Formatting;
Choose "Less Than" for "Cell value is" and type a number in the empty box;
Activate "Format";
Choose a "Color" from the color drop-down menu on the "Fonts" tab;
Click OK, OK.

=======

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.