Forum Discussion
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...
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)