Changing font colour to red & orange

[DDD]

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)

 

[Bob Phillips]

Use conditional formatting.

Select all the target cells, let's assume A2 is the first, and use CF
formulae of

=$F2<0 - use a red fill

and

=$F2=0 - use an orange fill

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)