How can I create an AutoFormat row color change for a value in a c
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
|