Im trying to create an inventory and each item has a different required quantity. I want the row of that item to highlight one of three colors based off of the actual stocked quantity of that item. i was able to create the three rules i wanted, but am not able to copy and paste the condition to the next row. it just carries the rules for the first row so that only row 2 will change all rows in worksheet...
attached is a screen shot of the worksheet and rules i have a created.. thanks so much
