Forum Discussion
cybrnitro
Jan 30, 2019Copper Contributor
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...
SergeiBaklan
Jan 30, 2019Diamond Contributor
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)