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.
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.
=======
