Spreadsheet: 705653d1606239543-conditional-formatting-if-some-condition-match-book1111-etaf
Sheet: Sheet1

S.No. | Name | Test Result
 |  | BP1 | BP2 | T1 | T2 | T3 | T4 | T5 | T6 | T7 | T8 | T9
1 | Head 1 | 312.65 | 243 | 345.25 | 358 | 365.75 | 340.95 | 342 | 344.65 | 349.07 | 4884218 | 64166
2 | Head 2 | 382.5 | 365.7 | 375.85 | 375.85 | 379.35 | 370.3 | 375.4 | 375.15 | 374.66 | 4065424 | 49565
3 | Head 3 | 370.7 | 331.75 | 384 | 385.6 | 389.6 | 375 | 378.95 | 379.65 | 381.64 | 806504 | 14270
4 | Head 4 | 126.9 | 123.5 | 124.05 | 124.5 | 124.7 | 122.35 | 123.15 | 122.8 | 122.97 | 121150 | 1619
5 | Head 5 | 827.3 | 815.5 | 858.05 | 869.65 | 879 | 863 | 876.7 | 874.4 | 871.66 | 1058661 | 28249
6 | Head 6 | 172.35 | 164.5 | 175.15 | 175.2 | 178.05 | 173.25 | 174 | 174 | 175.78 | 7865639 | 30685
7 | Head 7 | 94.15 | 91.7 | 90.8 | 91.9 | 92.45 | 89.8 | 91.2 | 91.25 | 91.29 | 34856235 | 90973
8 | Head 8 | 848.95 | 827.4 | 833.4 | 839.3 | 863.8 | 835.1 | 848 | 848.5 | 852.61 | 3455734 | 97571
9 | Head 9 | 490.5 | 485.8 | 497.3 | 501 | 502.6 | 496.6 | 497 | 498.4 | 499.65 | 210563 | 9949
10 | Head 10 | 646.1 | 637.4 | 643.1 | 646.3 | 648 | 633.6 | 645 | 644.3 | 641.01 | 921104 | 17537
11 | Head 11 | 185.05 | 179.2 | 185.9 | 188.15 | 189.5 | 183.05 | 185.75 | 186.1 | 186.48 | 498164 | 7660
12 | Head 12 | 16.1 | 15.85 | 17.15 | 17.4 | 17.9 | 16.85 | 17.1 | 17.05 | 17.4 | 1337033 | 2540
13 | Head 13 | 379 | 380.45 | 396.2 | 398 | 402.85 | 391.55 | 398.1 | 400.5 | 398.74 | 717748 | 35637
14 | Head 14 | 170.05 | 169 | 171.8 | 173.6 | 175.55 | 173.05 | 173.4 | 173.95 | 174.45 | 5196865 | 45388
15 | Head 15 | 58.6 | 57.15 | 58.45 | 59.1 | 59.55 | 57.85 | 58.35 | 58.3 | 58.52 | 29514760 | 60647
16 | Head 16 | 93.55 | 93.25 | 97.45 | 99 | 101.5 | 97.6 | 100.9 | 100.9 | 99.58 | 29687033 | 97296
17 | Head 17 | 25.4 | 24.9 | 25.15 | 25.25 | 26.95 | 25.15 | 26.5 | 26.45 | 26.27 | 29418210 | 51366
18 | Head 18 | 33.7 | 31.75 | 33.5 | 38.1 | 40.2 | 38.1 | 40.2 | 40.2 | 39.99 | 6639752 | 7218
19 | Head 19 | 2072.5 | 2056.5 | 2138.7 | 2149 | 2280 | 2130.05 | 2187.75 | 2197.65 | 2219.12 | 1174042 | 117246
20 | Head 20 | 51.85 | 48.65 | 57.65 | 60 | 62 | 56.25 | 57.85 | 57.9 | 58.7 | 3046743 | 14575
21 | Head 21 | 91.6 | 91.35 | 98.95 | 98.95 | 99.5 | 95.6 | 96.05 | 95.75 | 96.78 | 803930 | 9334
22 | Head 22 | 62.5 | 62.65 | 65.85 | 66.1 | 67 | 65.3 | 66.6 | 66.65 | 66.33 | 762919 | 5180
23 | Head 23 | 339.75 | 337.2 | 348.8 | 352.2 | 359.8 | 348.45 | 352.85 | 350.15 | 352.67 | 318313 | 8671
24 | Head 24 | 65.05 | 63 | 61.7 | 62 | 63.25 | 61 | 62.3 | 62.1 | 62.3 | 131982 | 1434
25 | Head 25 | 71.75 | 70.55 | 71.35 | 73 | 74 | 71.35 | 73.1 | 73.4 | 72.66 | 25493665 | 66067
26 | Head 26 | 282.6 | 269.25 | 282.85 | 284.9 | 292 | 284.7 | 289.9 | 290.4 | 288.91 | 4321845 | 42746
27 | Head 27 | 76.8 | 76.8 | 73.8 | 74.55 | 77.7 | 74.55 | 76.6 | 77 | 76.11 | 1171074 | 7574
28 | Head 28 | 134.7 | 129.85 | 139.55 | 140.9 | 148.3 | 140.8 | 144.9 | 146.6 | 145.23 | 31335476 | 143478
29 | Head 29 | 154.5 | 155.15 | 163.85 | 163.9 | 169.95 | 163 | 167.1 | 168.25 | 167.26 | 1952780 | 20956
30 | Head 30 | 54.3 | 52.95 | 53.4 | 52.75 | 54.05 | 52.75 | 53.6 | 53.55 | 53.64 | 1476644 | 4717
31 | Head 31 | 404.55 | 406.75 | 464.7 | 477.8 | 482 | 465.2 | 475.5 | 473.7 | 472.29 | 384292 | 23349
32 | Head 32 | 45.9 | 45.5 | 45.95 | 46.8 | 46.95 | 46.25 | 46.45 | 46.5 | 46.57 | 1576276 | 6239
33 | Head 33 | 239.5 | 231.1 | 242.75 | 243.5 | 246.15 | 238.1 | 238.6 | 238.7 | 240.76 | 57538324 | 258879
34 | Head 34 | 1410.9 | 1371.5 | 1425.3 | 1432.3 | 1432.3 | 1392 | 1397.45 | 1398.9 | 1407.38 | 451377 | 22602
35 | Head 35 | 7.4 | 7.2 | 6.8 | 6.9 | 7.4 | 6.85 | 7.3 | 7.3 | 7.19 | 32222448 | 56523
36 | Head 36 | 59.25 | 56.05 | 58.1 | 58.85 | 59.75 | 57.8 | 59.1 | 58.85 | 58.63 | 24196085 | 40207
37 | Head 37 | 42.3 | 41 | 44.5 | 44.9 | 46.6 | 43.7 | 44 | 44.15 | 45.11 | 1011200 | 3850
38 | Head 38 | 87.15 | 87.05 | 99.4 | 100.15 | 100.7 | 94.5 | 96.8 | 97 | 97.3 | 1755907 | 13139
39 | Head 39 | 8 | 8 | 8.1 | 8.35 | 8.55 | 8.1 | 8.15 | 8.15 | 8.31 | 23292067 | 38171
40 | Head 40 | 25.7 | 25.25 | 25.55 | 25.85 | 25.95 | 25.45 | 25.75 | 25.6 | 25.6 | 3738338 | 7847
41 | Head 41 | 318.7 | 292.55 | 393.3 | 410.3 | 451.9 | 405 | 428 | 434.75 | 431.42 | 7399858 | 165885