Forum Discussion

cybrnitro's avatar
cybrnitro
Copper Contributor
Jan 30, 2019

Conditional Formatting duplicating rules

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

  • You don't need to duplicate your rules if you use relative references (=$E2=$D2) and apply your rule to entire range (e.g. $A$2:$J$200)

Resources