Conditional Formatting

[Yiew]

Hey everyone,

I was looking for some help on some formals for conditional formatting. We have a weekly calibration going on within our lab and I was hoping for an excel spreadsheet to help keep traceability.
Essentially what is happening is we are comparing a known concentration (the standard) to an air quality meter to ensure the levels are being read correctly.

The standard has w = 10ppm, x = 50ppm, y = 18% and z = alarm (this will be based on a yes / no)

Assume w - z (the known values, not excel columns) are columns c - g (where they will be placed).
What I was hoping to achieve (if possible) was for column H to contain the word pass, and for it to highlight red or green if the values are correct (with 10% uncertainty). So for example, if all values read 10, 50, 18 and yes (for the alarm), then the word pass highlights green, but if all values read 5 (outside of 10% uncertainty of 10ppm), 50, 18 and yes, then the pass would highlight red.

Basically - I want all the values to be between 10% of their respective value for the instrument to pass (the alarm doesn't really matter too much; if this is not possible then a separate conditional format would be ideal).

As this spreadsheet will be used weekly, I will be using rows 2, 3 all the way until the file becomes exponentially too large, so I was hoping for a $c:$c type of thing (to include the entire column, not just to a certain value).

As you can see, this got complicated quick. I am out of my depth here. If none of this is possible I wont be too bummed, I would simply need a pass highlight for each value. Note: Is it possible to make it highlight red if outside of the known uncertainty?

[teylyn]

Hi,

can you post a spreadsheet sample to support the wall of text above? That will make understanding the issue so much easier.

cheers, teylyn