Ok i have a couple of records.

i want to change the font colour of specific cells in a row (Cells that are
in the columns A:G) to red when a value (In column F) in the same row reaches
a value smaller than 0 (Negative number).


If this value from before displays 0, i want the cells (In the columns
stated before) to change to an orange font colour

I think conditional formatting may need to be used but im not sure.

By the way, i am using Excel 2007. (Also what ever solutions you have must
also work in Excel 2003, as i open, edit, & save my workbook on both versions
quite frequently)