Forum Discussion
Function that automatically highlights cells with out of spec results for several parameters
Hello everyone,
I'm developing a QA lab at a small craft brewery and trying to get better documentation.
We recently started keeping track of several parameters for the brands that we produce (ABV, Extract, pH, CO2, etc). We have a spec sheet that shows the lower and upper limit of each parameter that we test for every brand.
Right now, we manually highlight cells with out of spec values. I want to develop an excel sheet that automatically highlights a value that's outside the acceptable range of a test parameter.
It gets tricky because each brand has different specs. ChatGPT suggested vlookup but I haven't been able to get the function to work. I assume I'm doing something wrong. Any help will be greatly appreciated.
1 Reply
- VLOOKUP(), XLOOKUP(), INDEX()/MATCH(), FILTER() all these functions should work in this case. Would you please post few sample data and expected output? You may attach a sample excel file to your post.
