Hello community. First time posting one of these so I hope it makes sense.
I am trying to use conditional monitoring to highlight a percentage loss from the Minimum recorded thickness (shown in V5-V29) from the original thickness (shown in D5-D29. I want to highlight the following:
I am trying to use conditional monitoring to highlight a percentage loss from the Minimum recorded thickness (shown in V5-V29) from the original thickness (shown in D5-D29. I want to highlight the following:
- Any numbers that are below a certain percentage (-12.6% mill tolerance) colored in red.
- Any numbers that are above a certain percentage (-12.5% mill tolerance) colored in green.
ISOs.xlsx | |||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | |||
3 | CML No: | CML Feat | NPS | Orig Thick | Dist From | Top | Bottom | North | East | South | West | Int | Ex | Min | |||||||||||
4 | ("/SCH) | (mm) | Start (mm) | Max | Min | Max | Min | Max | Min | Max | Min | Max | Min | Max | Min | Max | Min | Max | Min | Comments | |||||
5 | 1 | Straight (AW) | 30"/ Unk | 26.97 | 50 | 27.9 | 27.9 | 27.9 | 27.9 | 27.9 | |||||||||||||||
6 | 2 | Straight | 30"/ Unk | 26.97 | 2750 | 28.0 | 28.1 | 28.0 | 28.0 | 28.0 | |||||||||||||||
7 | 3 | Straight | 30"/ Unk | 26.97 | 6000 | 28.1 | 28.3 | 28.2 | 28.2 | 28.1 | |||||||||||||||
8 | 4 | Pipe Support | 30"/ Unk | 26.97 | 9400 | 28.0 | 28.1 | 28.3 | 28.2 | 28.0 | |||||||||||||||
9 | 5 | Straight (BW) | 30"/ Unk | 26.97 | 12030 | 28.1 | 28.0 | 28.2 | 28.1 | 28.0 | |||||||||||||||
10 | 6 | Straight (AW) | 30"/ Unk | 26.97 | 12080 | 27.6 | 27.9 | 27.8 | 27.9 | 27.6 | |||||||||||||||
11 | 7 | Straight | 30"/ Unk | 26.97 | 15540 | 27.8 | 27.9 | 27.9 | 28.0 | 27.8 | |||||||||||||||
12 | 8 | Straight | 30"/ Unk | 26.97 | 19290 | 27.9 | 27.9 | 28.0 | 27.9 | 27.9 | |||||||||||||||
13 | 9 | Pipe Support | 30"/ Unk | 26.97 | 21490 | 27.9 | 27.9 | 27.9 | 27.9 | 27.9 | |||||||||||||||
14 | 10 | Straight (BW) | 30"/ Unk | 26.97 | 24220 | 27.8 | 27.8 | 28.2 | 27.9 | 27.8 | |||||||||||||||
15 | 11 | Straight (AW) | 30"/ Unk | 26.97 | 24270 | 27.6 | 27.7 | 27.7 | 27.7 | 27.6 | |||||||||||||||
16 | 12 | Straight | 30"/ Unk | 26.97 | 27170 | 27.7 | 28.2 | 27.8 | 27.9 | 27.7 | |||||||||||||||
17 | 13 | Straight | 30"/ Unk | 26.97 | 30770 | 27.7 | 28.1 | 28.0 | 27.7 | 27.7 | |||||||||||||||
18 | 14 | Pipe Support | 30"/ Unk | 26.97 | 33630 | 27.6 | 27.8 | 27.7 | 27.8 | 27.6 | |||||||||||||||
19 | 15 | Straight (BW) | 30"/ Unk | 26.97 | 36360 | 27.7 | 27.5 | 27.7 | 27.5 | 27.5 | |||||||||||||||
20 | 16 | Straight (AW) | 30"/ Unk | 26.97 | 36410 | 27.6 | 27.9 | 27.8 | 27.7 | 27.6 | |||||||||||||||
21 | 17 | Straight | 30"/ Unk | 26.97 | 39610 | 27.7 | 27.6 | 27.8 | 27.7 | 27.6 | |||||||||||||||
22 | 18 | Straight | 30"/ Unk | 26.97 | 42910 | 28.1 | 28.1 | 27.8 | 27.8 | 27.8 | |||||||||||||||
23 | 19 | Pipe Support | 30"/ Unk | 26.97 | 45710 | 27.6 | 28.1 | 28.2 | 28.0 | 27.6 | |||||||||||||||
24 | 20 | Straight (BW) | 30"/ Unk | 26.97 | 48510 | 28.4 | 28.0 | 28.0 | 27.6 | 27.6 | |||||||||||||||
25 | 21 | Straight (AW) | 30"/ Unk | 26.97 | 48560 | 28.0 | 27.9 | 27.8 | 27.7 | 27.7 | |||||||||||||||
26 | 22 | Straight (BW) | 30"/ Unk | 26.97 | 50860 | 28.2 | 27.9 | 27.8 | 27.9 | 27.8 | |||||||||||||||
27 | 23A | Elbow (AW) | 30"/ Unk | 26.97 | 50910 | 29.7 | 30.0 | 30.0 | 30.0 | 29.7 | |||||||||||||||
28 | 23B | Elbow (Centre) | 30"/ Unk | 26.97 | 52110 | No Access | |||||||||||||||||||
29 | 23C | Elbow (BW) | 30"/ Unk | 26.97 | 53310 | No Access | |||||||||||||||||||
2277-050-020-ISO-058 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
V5:V27 | V5 | =MIN(F5:U5) |