Hi all, hopefully just a quick one for someone!
I'm setting up a control chart in Excel 2010 for some laboratory testing and I'm trying to have a Cell display "Run Pass" (Highlight in Green), "Run Fail" (Highlight in Red) or "Run Pass, raise QCP for one ref out of limits" (Green highlight) based on a number of scenarios.
What I have is a reference sample that is tested in duplicate in every run and it has to meet some criteria in order for the run to pass:
1: At least one of values should be within a certain range in order for the run to pass. If both are outside this range run fails, if both are in run passes. If one is in and one is out, run passes but we need to raise it in our quality system and I'd like it to display some sort of test rather than just "pass".
2: The difference between the two duplicates must be less than a value set in another Cell
Pretty much I want Cell F5 on Sheet 2 to display the Run Pass/Fail + appropriate highlights if Cell E5 on Sheet 2 is less than Cell F207 on Sheet 1, AND, if Cell D5 and D6 on Sheet 2 are Between Cells F211 and F212 on Sheet 1.
If Both D5 and D6 (sheet 2) are not between F211 and F212 on sheet 1 I want it to display the "Run Fail" text and appropriate highlight, BUT if one of them IS between, but the other not, I want it to show the Pass highlight, but a different text than just "Run Pass", something like: "Run Pass, Raise QCP for 1 Ref outside of limits"
Pretty complicated I'm sorry. Far beyond my (limited) expertise in excel!
Thanks in advance!!
Jarred.
I'm setting up a control chart in Excel 2010 for some laboratory testing and I'm trying to have a Cell display "Run Pass" (Highlight in Green), "Run Fail" (Highlight in Red) or "Run Pass, raise QCP for one ref out of limits" (Green highlight) based on a number of scenarios.
What I have is a reference sample that is tested in duplicate in every run and it has to meet some criteria in order for the run to pass:
1: At least one of values should be within a certain range in order for the run to pass. If both are outside this range run fails, if both are in run passes. If one is in and one is out, run passes but we need to raise it in our quality system and I'd like it to display some sort of test rather than just "pass".
2: The difference between the two duplicates must be less than a value set in another Cell
Pretty much I want Cell F5 on Sheet 2 to display the Run Pass/Fail + appropriate highlights if Cell E5 on Sheet 2 is less than Cell F207 on Sheet 1, AND, if Cell D5 and D6 on Sheet 2 are Between Cells F211 and F212 on Sheet 1.
If Both D5 and D6 (sheet 2) are not between F211 and F212 on sheet 1 I want it to display the "Run Fail" text and appropriate highlight, BUT if one of them IS between, but the other not, I want it to show the Pass highlight, but a different text than just "Run Pass", something like: "Run Pass, Raise QCP for 1 Ref outside of limits"
Pretty complicated I'm sorry. Far beyond my (limited) expertise in excel!
Thanks in advance!!
Jarred.