Spreadsheet: 161951d1339680235-conditional-formatting-copy-of-excel-problem2
Sheet: Sheet1

 |  | Label | Label | Label | Label | Label | Label | Label | Label | Label |  | 11000
 |  | 11 | 3 | 5.34 | 1 | 1 |  |  |  | 4000
 |  | 11 | 3 | 5.34 | 1.158 | 1.158 | 7.655999999999999 | 9.404388714733543 | 103.448275862069 | 6000
 |  | 12 | 3 | 5.34 | 1.213142857142857 | 1.213142857142857 | 7.766285714285715 | 9.270840997719077 | 111.2500919726289 | 6452.505334412477
 |  | 13 | 3 | 5.34 | 1.268285714285714 | 1.268285714285714 | 7.876571428571427 | 9.141033081834012 | 118.8334300638422 | 6892.338943702845
 |  | 14 | 3 | 5.34 | 1.323428571428571 | 1.323428571428571 | 7.986857142857144 | 9.01481004507405 | 126.2073406310367 | 7320.025756600128
 |  | 15 | 3 | 5.34 | 1.378571428571429 | 1.378571428571429 | 8.097142857142856 | 8.892025405786875 | 133.3803810868031 | 7736.06210303458
 |  | 16 | 3 | 5.34 | 1.433714285714285 | 1.433714285714285 | 8.20742857142857 | 8.772540555594237 | 140.3606488895078 | 8140.917635591451
 |  | 17 | 3 | 5.34 | 1.488857142857143 | 1.488857142857143 | 8.317714285714285 | 8.656224237427866 | 147.1558120362737 | 8535.037098103876
 |  | 18 | 3 | 5.34 | 1.544 | 1.544 | 8.427999999999999 | 8.54295206454675 | 153.7731371618415 | 8918.841955386808
 |  | 19 | 3 | 5.34 | 1.599142857142857 | 1.599142857142857 | 8.538285714285713 | 8.432606076830412 | 160.2195154597778 | 9292.731896667114
 |  | 20 | 3 | 5.34 | 1.654285714285714 | 1.654285714285714 | 8.648571428571428 | 8.325074331020815 | 166.5014866204163 | 9657.086223984146
 |  | 21 | 3 | 5.34 | 1.709428571428571 | 1.709428571428571 | 8.758857142857142 | 8.220250521920669 | 172.625260960334 | 10012.26513569937
 |  | 22 | 3 | 5.34 | 1.764571428571428 | 1.764571428571428 | 8.869142857142856 | 8.118033631853617 | 178.5967399007796 | 10358.61091424522
 |  | 23 | 3 | 5.34 | 1.819714285714286 | 1.819714285714286 | 8.97942857142857 | 8.018327605956472 | 184.4215349369989 | 10696.44902634593
 |  | 24 | 3 | 5.34 | 1.874857142857143 | 1.874857142857143 | 9.089714285714285 | 7.921041051109574 | 190.1049852266298 | 11026.08914314453 |  | Require the adjacent cells (C16 : J16) in this row to be formatted (highlighted) the same as K16
 |  | 25 | 3 | 5.34 | 1.93 | 1.93 | 9.2 | 7.826086956521739 | 195.6521739130435 | 11347.82608695652
 |  | 26 | 3 | 5.34 | 1.985142857142857 | 1.985142857142857 | 9.310285714285714 | 7.733382434174185 | 201.0679432885288 | 11661.94071073467
 |  | 27 | 3 | 5.34 | 2.040285714285714 | 2.040285714285714 | 9.420571428571428 | 7.642848477496058 | 206.3569088923936 | 11968.70071575883
 |  | 28 | 3 | 5.34 | 2.095428571428571 | 2.095428571428571 | 9.530857142857142 | 7.554409736794772 | 211.5234726302536 | 12268.36141255471
 |  | 29 | 3 | 5.34 | 2.150571428571429 | 2.150571428571429 | 9.641142857142857 | 7.467994310099574 | 216.5718349928876 | 12561.16642958748
 |  | 30 | 3 | 5.34 | 2.205714285714286 | 2.205714285714286 | 9.751428571428571 | 7.383533548198066 | 221.506006445942 | 12847.34837386464
 |  | 31 | 3 | 5.34 | 2.260857142857143 | 2.260857142857143 | 9.861714285714285 | 7.300961872754665 | 226.3298180553946 | 13127.12944721289
 |  | 32 | 3 | 5.34 | 2.316 | 2.316 | 9.972 | 7.220216606498195 | 231.0469314079423 | 13400.72202166065
 |  | 33 | 3 | 5.34 | 2.371142857142857 | 2.371142857142857 | 10.08228571428571 | 7.141237814554524 | 235.6608478802993 | 13668.32917705736
 |  | 34 | 3 | 5.34 | 2.426285714285714 | 2.426285714285714 | 10.19257142857143 | 7.06396815608006 | 240.1749173067221 | 13930.14520378988
 |  | 35 | 3 | 5.34 | 2.481428571428571 | 2.481428571428571 | 10.30285714285714 | 6.988352745424294 | 244.5923460898503 | 14186.35607321132
 |  | 36 | 3 | 5.34 | 2.536571428571428 | 2.536571428571428 | 10.41314285714286 | 6.91433902211491 | 248.9162047961368 | 14437.13987817593
 |  | 37 | 3 | 5.34 | 2.591714285714285 | 2.591714285714285 | 10.52342857142857 | 6.841876629018245 | 253.1494352736751 | 14682.66724587315
 |  | 38 | 3 | 5.34 | 2.646857142857143 | 2.646857142857143 | 10.63371428571429 | 6.770917298081573 | 257.2948573270998 | 14923.10172497179
 |  | 39 | 3 | 5.34 | 2.702 | 2.702 | 10.744 | 6.701414743112435 | 261.355174981385 | 15158.60014892033
 |  | 40 | 3 | 5.34 | 2.757142857142857 | 2.757142857142857 | 10.85428571428571 | 6.6333245590945 | 265.33298236378 | 15389.31297709924
 |  | 41 | 3 | 5.34 | 2.812285714285714 | 2.812285714285714 | 10.96457142857143 | 6.566604127579737 | 269.2307692307692 | 15615.38461538462
 |  | 42 | 3 | 5.34 | 2.867428571428571 | 2.867428571428571 | 11.07485714285714 | 6.501212527733349 | 273.0509261648007 | 15836.95371755844
 |  | 43 | 3 | 5.34 | 2.922571428571429 | 2.922571428571429 | 11.18514285714286 | 6.437110452641258 | 276.7957494635741 | 16054.1534688873
 |  | 44 | 3 | 5.34 | 2.977714285714285 | 2.977714285714285 | 11.29542857142857 | 6.374260130520566 | 280.4674457429049 | 16267.11185308848
 |  | 45 | 3 | 5.34 | 3.032857142857142 | 3.032857142857142 | 11.40571428571429 | 6.312625250501002 | 284.0681362725451 | 16475.95190380761
 |  | 46 | 3 | 5.34 | 3.088 | 3.088 | 11.516 | 6.252170892671066 | 287.599861062869 | 16680.7919416464
 |  | 47 | 3 | 5.34 | 3.143142857142857 | 3.143142857142857 | 11.62628571428571 | 6.192863462105573 | 291.064582718962 | 16881.74579769979
 |  | 48 | 3 | 5.34 | 3.198285714285714 | 3.198285714285714 | 11.73657142857143 | 6.134670626612786 | 294.4641900774137 | 17078.92302449
 |  | 49 | 3 | 5.34 | 3.253428571428571 | 3.253428571428571 | 11.84685714285714 | 6.077561257958711 | 297.8005016399769 | 17272.42909511866
 |  | 50 | 3 | 5.34 | 3.308571428571428 | 3.308571428571428 | 11.95714285714286 | 6.021505376344087 | 301.0752688172043 | 17462.36559139785
 |  | 51 | 3 | 5.34 | 3.363714285714285 | 3.363714285714285 | 12.06742857142857 | 5.96647409792594 | 304.290178994223 | 17648.83038166493
 |  | 52 | 3 | 5.34 | 3.418857142857143 | 3.418857142857143 | 12.17771428571428 | 5.912439585190747 | 307.4468584299188 | 17831.91778893529
 |  | 53 | 3 | 5.34 | 3.474 | 3.474 | 12.288 | 5.859375 | 310.546875 | 18011.71875