Changing font colour to red & orange
 

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)

Changing font colour to red & orange
 

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)

"DDD" wrote in message
...
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)