How can I create an AutoFormat row color change for a value in a c

[Shane Rary]

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

 

[Guest]

Hi

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

Andy.