Hello all, I am in need of some assistance with Excel.
I made the decision to have my QA team (myself and 1 other) switch from handwritten logs to electronic logs due to many reasons, the main 2 being illegible handwriting and convenience. My plan is to have the QA Supervisor perform her tests as usual, but then record results into the spreadsheet and email me (QA Director) the completed sheet daily for review and approval.
Anyway...I need help with excel conditional formulas. Right now I'm working on our brine log and I'm stumped on how to achieve what I want, if it's even possible without installing a bunch of widgets. I attached a basic copy below.
So date, time, batch # are entered. The tank is chosen from a drop-down list (you can see drop-down lists in the second tab). Then, the Brine recipe (Column E) is chosen from a drop-down menu. Here's what I'd like to be able to do...
When a certain brine recipe is chosen (ex: Brine 1), I want the pH, salt, and brix in that row to have conditional formatting based on what's set for that brine recipe.
Is there a way I can do something like... IF E5="Brine 1", then F5 must be between VALUE1-VALUE2, G5 must be between VALUE3-VALUE4, and H5 must be between VALUE5-VALUE6. And if the data entered are outside of those ranges, the cell turns red. And if E5="Brine 2" then F5, G5, and H5 must be between the values for that recipe or else the cell will turn red.
If it's not possible without becoming very complicated, that's ok! It's not necessary, I just thought it'd be nice to have a visual trigger like a cell turning red.