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



"Bob" wrote:

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?