software

I use Microsoft Excel to keep track of our inventory. I have a formula on my
quot;Quantity to Orderquot; 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

Hi

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

Andy.

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