Hi everyone,
My company asked me to automate control of certain specifications of products, i would use conditional formatting in order to highlight data that are out of range.
but my issue is that first i have to check which product i'm dealing with and then compare this to a range of data,
for ex:
product A spec1 is between 1-10, spec 2 is between 20-30.
product B spec1 is between 5-15, spec 2 is between 25-35.
if I enter the specs for product B is want to check if the specs are in range for product B, if not highlight them.
Does anyone have any ideas on how this can be done efficiently, because I'm dealing with about 20 products with each around 6 specifications.
Thank you in advance
Wes
Bookmarks