Changing font color if conditions are met

[Bob]

I am trying to change the font to red if the result of a formula is less then
0. I would like to change this within the formula instead of manually. Any
suggestions?

 

[krcowen]

Conditional formatting.
Ken

 

[Mike H]

Bob,

Select the cell then

Format|Conditional format - cell value is - less than - enter a 0
pick you font colour
OK

Use the format painter to copy the format condition to other cells.

Mike

 

[T. Valko]

You can do this using a custom number format:

Select the range of cells in question. Assume this range is A1:A10
Goto the menu Format>Cells>Number tab>Custom
Enter this string in the little box labeled TYPE:

General;[Red]-General;0;@

OK out

Or, you can do it using conditional formatting:

Select the range of cells in question. Assume this range is A1:A10
Goto the menu Format>Conditional Formatting
Select the Formula Is option
Enter this formula in the box on the right:
=A1<0
Click the Format button
Select the Font tab
Select Color: RED
OK out

 

[Bob]

Thanks that works fine.....

Bob,

Select the cell then

Format|Conditional format - cell value is - less than - enter a 0
pick you font colour
OK

Use the format painter to copy the format condition to other cells.

Mike