Hi Chris
Highlight the column in question
Have a look at Format / Conditional Formatting
In the first box, select Cell value is
Inthe second box, select is lees than
and the last box, 0
Then format as required and click OK

HTH
Michael Mitchelson


"Chris" wrote:

Hi,
How do set the cell font color to red if the value is a minus ("-") amount
like -2 and if a positive like 2, then it remains black. I want this formula
to be on all rows on a specific column.

Thanks