Hi

Select the row and use this in CF:
=$A2<0
presuming A2 is your cell!

Andy.

"Shane Rary" <Shane wrote in message
...
I use Microsoft Excel to keep track of our inventory. I have a formula on
my
"Quantity to Order" column that allows the program to automatically change
the cell color to red when the value gets below zero. Is there a way that
I
can use this same numerical limit to change the color of the entire row?
If
so, can you give me the formula, or something similar? Thanks, Shane