View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shane Rary
 
Posts: n/a
Default 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