Spreadsheet: 582529d1531924050-vba-for-filling-cells-with-colours-of-specific-values-sampleset
Sheet: Desired Result

Q | Factor
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 |  | R | G | B
1 | 0.544766281980102 | -0.03117299187514196 | 0.05229532210639511 | 0.1341629919052978 | 0.08393729670594739 | 0.09834297607982403 | 0.004609159939633681 | 0.0228073748975557 | 0.04887129433585026 | -0.05793397272639884 | -0.05469714405426662 | 0.008123007810506256 | 0.1104649420414716 | -0.08016669458028132 | 0.3 - 0.399 | 182 | 247 | 159
2 | 0.5382614674113547 | -0.1040783281935305 | -0.02876961588306485 | 0.2402427296070006 | -0.02822191230487609 | 0.06712491325142185 | -0.01509427675118759 | -0.01814971522975389 | 0.0239007410282815 | 0.05462113768052077 | -0.1007994697920667 | 0.04978315786385952 | 0.01383012763780938 | 0.03219700286617523 | 0.4 - 0.499 | 16 | 230 | 36
3 | 0.4487255627150556 | 0.03081955314709142 | 0.0306869338567722 | 0.04660392131604566 | 0.00417686128234252 | -0.1279770536568968 | 0.12953856412775 | -0.08010192104249494 | -0.1702155818384025 | -0.1056097656989951 | 0.08775026170362862 | 0.1814232962821002 | -0.0263840685559195 | -0.2582985171068558 | 0.5 - 0599 | 8 | 180 | 8
4 | 0.4478093227778359 | -0.07261966091993673 | 0.04498377209137176 | 0.1066725998613968 | 0.09587439855103871 | 0.07948544044364633 | 0.04385865704145651 | 0.1872600009543461 | -0.02525640933991587 | -0.01202000292673526 | -0.002704542542575471 | -0.006773178700484545 | 0.1695241747649437 | 0.00186521253772207 | <0.6 | 5 | 99 | 5
5 | 0.3940465226802826 | -0.01721459146804953 | -0.1760288875502494 | 0.07488508705362351 | 0.2564617402244657 | -0.08135345853973379 | 0.02919259919906044 | -0.07362620885063113 | -0.02117233750155312 | 0.08089489875320988 | 0.2164966199328016 | 0.006914383597367819 | 0.07592405721916531 | -0.1903136053973128
6 | 0.3857255335629017 | -0.05440038389721071 | 0.1704057569290432 | 0.09764825263091972 | -0.06427172002564169 | 0.1168743533469764 | -0.1251222781976932 | -0.03011891472659376 | -0.02699527168334882 | -0.01051797442582427 | -0.1940462572817185 | 0.01428959409248218 | 0.1662076465374465 | -0.03063188448515049
7 | 0.384472201149237 | -0.03039983437617791 | 0.1322059025087848 | 0.006755695263067568 | -0.07507230548320526 | 0.227598563140252 | -0.01562842709682718 | 0.06091119767654615 | 0.0331424921370377 | 0.02754600616731019 | -0.1004641785295939 | -0.09232782283343288 | 0.1577028894113644 | -0.1198443307062727
8 | 0.3529059523371049 | -0.1949282133114926 | 0.06215718967739628 | 0.03833605694068867 | -0.09568308762622817 | 0.1884909260067405 | 0.05748381678693876 | -0.132311042109209 | -0.1357200291478271 | 0.06283043441259101 | -0.01024011358729076 | -0.1104384993980404 | 0.1158033761687085 | 0.0442893995809305
9 | 0.3518441708737859 | -0.0659410507853257 | 0.02469602681042063 | 0.162428680567107 | -0.1996698496230746 | 0.09890577577893794 | 0.1979214621909449 | -0.02000668195935429 | -0.1660528270736527 | 0.01231054163436896 | -0.003169884945316229 | 0.002937059887376537 | -0.1290715580384014 | -0.258202935778983
10 | 0.3421464008565644 | -0.1011500080701696 | -0.1392709020500729 | 0.2089919416414844 | 0.1202049087111588 | 0.04381658666416303 | 0.02633429368768743 | -0.2215255954966094 | 0.1602798724311462 | 0.03813208555089521 | -0.07412491836188925 | 0.1314021112426778 | 0.1190878523406255 | 0.005882454393965579
11 | -0.03914952513760464 | 0.5605855766397947 | 0.04781559985866906 | -0.004787823008333302 | 0.03577019168797776 | 0.01167329374694883 | -0.003510349097808491 | -0.002625045121190542 | -0.04694495085954267 | 0.09776404533668903 | 0.01637325593997897 | 0.1081461148005475 | 0.02678905473920215 | 0.02786510495809816
12 | 0.04227347260305128 | 0.5427868973569151 | 0.00866472076430641 | -0.1552998749370582 | -0.1129916328856219 | -0.04302370677750591 | -0.0660058144202834 | 0.1902006809906777 | -0.01302650110925966 | 0.009378288415208482 | 0.06060659153806442 | -0.3687591846028145 | 0.02899998956484652 | -0.1288701929667873
13 | 0.0588133562191784 | 0.4519223586399217 | -0.1078880619937637 | -0.02017998956006569 | 0.1611369321087911 | -0.08918007154203794 | -0.1271980550134931 | -0.06952641905099692 | -0.1083236398757763 | 0.07659272616730237 | -0.05822267737046385 | 0.01136318951965185 | -0.4135762061934933 | 0.03188564919112122
14 | -0.09749893031223075 | 0.44400469589421 | 0.1220239913927232 | 0.02258325506588126 | 0.1173650095797441 | 0.0180387321203915 | -0.05615943061457902 | 0.009315454167035416 | 0.04833688125996875 | -0.03891346027261087 | -0.1704223600382378 | -0.084853986115928 | 0.0100752745452225 | 0.1006386299668206
15 | 0.05902235157663437 | 0.3768707938899328 | -0.1976546709154648 | 0.1092098060777913 | -0.01388405619335021 | -0.08938832314249545 | -0.002777697336742056 | -0.1291928840040076 | 0.08908349017240348 | 0.09068475367637725 | -0.1667407568290361 | 0.1242938747286375 | -0.007528354860966819 | 0.004048132565849487
16 | -0.2352690349109 | 0.3608182757960565 | -0.003150654258955231 | -0.04915787178694399 | 0.01575635376181329 | 0.02033999276375345 | 0.1221922761461766 | -0.3486734211575691 | 0.1287646980954753 | 0.04002991643456096 | -0.08965060420004825 | -0.02611909745409711 | -0.1322162065168925 | 0.03019458338570301
17 | -0.2022687102697455 | 0.3492967470178114 | 0.09987010070192229 | 0.1182852092661226 | 0.05970317569314029 | 0.07342089211150252 | 0.05807404588733926 | -0.0361620616599727 | -0.1339675814070468 | 0.0190523999030375 | -0.09510367336087862 | -0.03345119989073052 | -0.243466665172147 | -0.06702649634672686
18 | -0.03179268216775431 | 0.2896665058713076 | -0.09261851452853523 | -0.01044890349598871 | -0.1392288443833516 | -0.05132566650651445 | 0.04284080954505357 | -0.135265098083045 | -0.1099616519135088 | 0.1739481298792223 | -0.173276975811755 | -0.1434967777057801 | -0.08492687664052327 | -0.2095708030203826
19 | 0.05836381248060045 | 0.2511080135752957 | 0.08206231358376632 | -0.05893412663376461 | 0.08020975863300533 | -0.2503201962106036 | -0.02785775943584139 | -0.06819219116064083 | -0.08912812349868003 | -0.1210750921840027 | -0.1667452941287525 | -0.1169248457155131 | -0.01191023507709095 | -0.0624218172649743
20 | 0.07686683307188136 | 0.0447000804286343 | 0.5171571027913476 | 0.05107422764666566 | 0.3348698087428583 | 0.01163055682111466 | 0.03003198263614923 | 0.002797507553621717 | -0.04208905286043002 | 0.01753709090933243 | 0.02855296080336291 | -0.05101820517151292 | -0.1306564687452549 | -0.0532970491481338
21 | 0.02061686273139669 | 0.1457166490438027 | 0.4900313401250618 | 0.01764013091708237 | 0.02797805259299879 | -0.3026388862147179 | 0.01231355852044711 | 0.03017808401981917 | -0.223764691823622 | 0.02227533183913983 | -0.1260516232654002 | -0.2273924014499273 | 0.05868286691326575 | 0.02881718225026335
22 | 0.107566643767992 | -0.06113659541518676 | 0.4149099385159766 | 0.1214170596818425 | 0.08884183936982101 | 0.1763461310729437 | 0.09400230206583508 | -0.1804973798490003 | -0.2081396835458544 | -0.04805972477469881 | -0.003000268615663048 | 0.07361286053836087 | 0.1688195305285405 | 0.2039788233175284
23 | -0.0943449122686283 | 0.1134271280174876 | -0.4102887087394926 | 0.1216706226932092 | 0.2882667741449532 | 0.02893969547057605 | 0.07263416073894198 | -0.121173267188417 | -0.07943140199338969 | 0.04655907703582082 | -0.07691936488890722 | -0.01250242061164708 | -0.05369305837251098 | -0.005823017908911223
24 | 0.160865993592193 | 0.1340430470858872 | 0.3611813149279546 | -0.04530733671335648 | 0.02827592178815263 | -0.2987421642528027 | 0.09066966206300903 | -0.1559482009356595 | 0.07605210445738483 | -0.02972167997947515 | -0.1835389670235174 | -0.2137650303950905 | -0.1013549228853219 | -0.02089694014831247
25 | -0.08445083699717536 | 0.2954798039557263 | 0.328126263773185 | -0.03519755228128526 | -0.1189080032062112 | 0.03033114929720473 | -0.05288491995338347 | -0.05526394317295948 | 0.09060023510966453 | -0.00165769709172904 | -0.07828145684212989 | -0.06925219446259039 | -0.05187500613511129 | -0.0909562672110711
26 | -0.01268639546045624 | 0.03657603665915594 | 0.00741568135962547 | 1.003968706793694 | -0.1172796014924987 | -0.1579696612807916 | -0.04299326658129861 | 0.05618450531414947 | 0.07696263928054484 | -0.0300624438557731 | 0.06546454889043762 | -0.07108087399512751 | 0.02109166166130505 | 0.007761584185731807
27 | -0.04417287939678972 | -0.04368574430715786 | 0.03215858649210517 | 0.8282941941219418 | -0.021454336609999 | -0.07623139324095739 | -0.007208108056741771 | 0.06808433717754228 | -0.01926653528111471 | -0.03031714040598469 | 0.06292091113863019 | -0.002218024166266957 | -0.02495575668277457 | -0.1107352808648814
28 | 0.06321751628949736 | 0.04377759808073064 | 0.05531402098209733 | 0.3326303080499167 | -0.1954213166636661 | 0.09068583015941865 | -0.06020741875795818 | -0.1718510534933889 | -0.1457745369110466 | 0.1385123797970499 | -0.01150581021329116 | -0.09535814885339998 | -0.006647149254085791 | -0.1541668304780206
29 | 0.1568418514859874 | -0.09812038097536119 | -0.04702198037162097 | 0.2949019859368827 | -0.1700025869165831 | 0.2880721972749872 | 0.1330932378248251 | -0.079028833246687 | -0.09105739183853932 | 0.09439795392291048 | -0.1450519486943469 | 0.04004283961599807 | -0.004815530497493081 | 0.01366924743616588
30 | 0.1330606055416576 | -0.061394850582741 | 0.04331630028659388 | 0.06204372293831806 | 0.3643987114589524 | -0.01081566135075215 | -0.0327353763937589 | -0.02975464811339346 | 0.03726418957428668 | 0.08195793784226768 | 0.006259366472538395 | 0.00680752524671342 | -0.1121949546097615 | -0.3133747114935193
31 | 0.2659559265365562 | 0.0253879735992274 | -0.01796678315784416 | 0.1557440286291282 | 0.2729327285497609 | -0.07966842365473169 | 0.1539593710468479 | -0.05930127067295484 | -0.1887436125038646 | 0.05298921292959057 | 0.2170427011553487 | 0.1530809286210772 | 0.2387597238798924 | -0.004481974925959364
32 | 0.09241497351888843 | 0.01103783783597358 | -0.2037949904369146 | 0.1652860705218223 | 0.2199598088749802 | 0.06760775462221376 | 0.0824769711193022 | -0.1738697083963887 | -0.2140615699861687 | -0.04920835711078766 | -0.04479161144594673 | 0.09926179998293157 | -0.03002348654873383 | -0.1040197265477741
33 | 0.2203304991039256 | 0.08104401744397104 | 0.00744431136390592 | 0.04545407076775487 | 0.2167955833340085 | 0.4150053247490923 | -0.09498633615004466 | 0.02279178608814817 | 0.05260593702199708 | 0.08373122989556611 | 0.01542014646794189 | -0.1165261439091602 | 0.001852255605702669 | -0.07843658587790599
34 | 0.01878765388681834 | 0.06156875060924798 | 0.2452621333045815 | 0.1254232183107521 | 0.1472493827965528 | 0.3062089688712507 | -0.2354175728583863 | -0.1394864548426522 | -0.0556370755350749 | 0.02538773885147102 | 0.1302034153299241 | 0.1123572229072478 | 0.1239439535160489 | -0.2267047956656351
35 | 0.2704874061494657 | -0.0445183158595647 | 0.1573036103862781 | 0.1322108742644369 | 0.009636916117379752 | 0.3037111219130916 | -0.03067700006912973 | -0.1326266774556116 | 0.009686838590160821 | 0.05570000377220207 | 0.0244818532642693 | 0.01659870214392375 | 0.1116742517924561 | 0.1058107041368513
36 | 0.1282949653201637 | -0.01528976356142503 | -0.06026182183763695 | 0.1295554399706478 | -0.1622272887551756 | 0.2059315562581974 | 0.4423473180010457 | -0.1949056597935683 | -0.1020708605687689 | 0.01859076083240961 | 0.03972301344280769 | -0.03924965184754044 | -0.03335269208123924 | -0.05613451820317285
37 | 0.303329341157915 | -0.04714512463621405 | 0.178991701079756 | 0.0636354509111904 | 0.089336813231878 | -0.01038778707595273 | 0.3498158309488815 | -0.01606469206855256 | -0.0624133149249007 | -0.01409495069306895 | 0.0604947333965637 | 0.05750603441032009 | 0.2501091895630796 | -0.03075683267731653
38 | -0.09908793688533905 | 0.005936713695507988 | -0.2179365643913011 | 0.202345062681731 | 0.2763364485251341 | 0.2595987833862947 | 0.3447208804506897 | 0.06640617853769307 | -0.08941370197775171 | -0.1219959084538308 | 0.1364978003168132 | 0.01747934865809397 | 0.06647159652494951 | -0.0989723106237999
39 | 0.06027042593019281 | 0.08648151295370358 | -0.1489632025775826 | 0.04735379507795872 | -0.165582990237529 | -0.06583151134031089 | 0.08486760861546266 | -0.399249630272603 | -0.1021530968489485 | 0.24701306601579 | 0.2436357435169918 | 0.05369809601366112 | 0.08758514862099882 | -0.2746859472137583
40 | 0.1761488177848907 | -0.01014963732745903 | -0.08594034557544285 | 0.07422436311462634 | -0.1148241471821324 | -0.05909482276199746 | 0.1153705787384957 | -0.3686266288526144 | -0.05221719709437879 | 0.1442975267525425 | 0.3497865394637675 | -0.02086326817436668 | 0.1270299429314124 | -0.2551823244970295
41 | 0.01814307280646105 | -0.01370888473138337 | 0.2270506759347692 | -0.02004267052964088 | -0.02808140963431816 | 0.2155178426406384 | -0.07531500897785522 | -0.3241777822384086 | -0.08480920521372173 | 0.1475916861647148 | -0.04445827243090972 | 0.02008549016859218 | 0.1504554618736734 | -0.0313617386465282
42 | 0.1820790716086997 | 0.02529594950445144 | -0.03686513915930219 | 0.05869919243317214 | -0.00529553349179818 | -0.06325208167832679 | 0.05015557013038174 | -0.006910445508563213 | -0.3734293246163208 | 0.03948086891329867 | -0.2591389819187884 | 0.05615361395257982 | 0.02049218324930265 | -0.05569134166319317
43 | 0.139705479011849 | 0.02646136071701014 | -0.1581822424403489 | 0.1007225520009605 | 0.1791099032181829 | 0.06511409606779676 | 0.09683061835096632 | -0.06910854417469763 | 0.3673098245708989 | 0.03638453890150154 | -0.1000275929775998 | 0.05541916449284869 | 0.1676377153699951 | -0.09566002376611173
44 | -0.1166006306113816 | -0.09491529812903003 | -0.227905987698387 | -0.006693474690306775 | 0.2993507773118613 | -0.01909646082680935 | -0.01870104823343405 | -0.1162058924537875 | -0.3021706976446251 | 0.1598502581226476 | -0.1563380432097037 | -0.2415260902900497 | 0.1067495110388206 | -0.1192752507885346
45 | -0.1091883160214433 | 0.02743949540659163 | 0.1394721904150238 | 0.02563606203655605 | -0.01599750629490301 | 0.0506104282030828 | 0.293910112854337 | 0.3586575450838921 | 0.04098605156243079 | 0.5301031124382664 | -0.06817995114424075 | 0.03111180100211236 | -0.06632543071106446 | 0.1558257357158987
46 | 0.1408286752536792 | -0.001892100690774184 | 0.1811906285879122 | -0.008053531121267964 | 0.03681271930510373 | 0.2575053508794459 | 0.2435270672609764 | -0.228168989233507 | 0.001819300056433992 | -0.3830730207065759 | -0.07405508195893233 | -0.03609071072018877 | 0.08080858045487689 | -0.03793242177595492
47 | 0.06544581052567203 | 0.1924159313896512 | -0.03791373640924692 | -0.01549446442221073 | 0.1711072125727464 | 0.177786549271649 | -0.1182174682168688 | -0.0248760602885827 | -0.1011718710242285 | 0.2277688174238071 | -0.00117387111141744 | -0.1038586080297082 | -0.03773901656929381 | -0.2057784148564059
48 | 0.1250422420371625 | 0.08927001198836591 | -0.05431269749575632 | 0.1976556848587752 | 0.06012656731956451 | 0.1950016301015691 | -0.05640716854960597 | -0.03860927271737934 | -0.07018683532845107 | 0.09860562389700246 | -0.209623402175096 | 0.03145797320444494 | 0.07529345918877918 | 0.1003207616863491
49 | 0.04190341118990474 | 0.4469839476476523 | -0.09807586905248605 | -0.02346252994223371 | -0.1287811658069176 | 0.1826030931974905 | -0.01417271985589845 | 0.0552567364671346 | -0.04330928482779524 | -0.1109455954925934 | 0.1482515405367186 | -0.5857611586909233 | -0.1014042968334682 | 0.02244997234835571
50 | -0.03277634074117856 | -0.0376152851303669 | 0.1570752339401325 | 0.07075621970609479 | 0.03912305541777244 | -0.1976218106255236 | -0.01153986985331558 | -0.2516949404062685 | 0.1479151902626084 | 0.1576454513266135 | -0.1008338866792443 | -0.446216350635053 | 0.06516609657028667 | 0.0269471276260363
51 | 0.04183281232707617 | 0.05265099330288545 | -0.04313727364873642 | 0.1005046887380608 | 0.03883783146150797 | -0.01664147471561567 | 0.07985065518679454 | -0.1658189080844277 | -0.09645631054745211 | 0.08907465595534464 | -0.1696794590745368 | -0.347608219606474 | 0.004679463726224004 | 0.01696416499334747
52 | 0.09288109431752928 | 0.08100394591545167 | 0.02706839844119174 | 0.01525820408076074 | 0.06829657901595979 | -0.05577384711334875 | 0.2849809962054626 | 0.05984456952281208 | 0.06736009479882449 | -0.0498393117505217 | -0.0661582677984644 | 0.08258550756632621 | 0.5340590269525234 | -0.2120899430974011
53 | 0.1742795209179499 | 0.00784058987800414 | 0.005730830663382371 | 0.1073582080914364 | 0.1938202489279326 | -0.1405943763197793 | 0.06291289111890108 | -0.1443494883408267 | -0.2028187868979111 | 0.03109731653354677 | 0.2495645738015611 | 0.08387712712996616 | 0.4924506456912744 | 0.07986525315526001
54 | 0.02031433390212362 | -0.1223760580272371 | 0.1960675725060326 | 0.004824267529013024 | 0.06025664786052531 | 0.3003415194239634 | 0.3135241552127861 | 0.03998381348981498 | 0.04019176803597099 | -0.09655051884386459 | 0.04262688390780011 | -0.06679956047711866 | 0.3618154508284821 | -0.0837354829326265
55 | -0.1115726571049689 | -0.04563655120790581 | 0.2400252036381043 | -0.004263357584363468 | 0.1862542214420631 | 0.004439936655277421 | 0.1446988961748211 | -0.1737734484836098 | 0.1352052260907265 | 0.03850225903640559 | -0.1797396082168378 | -0.16980969690779 | -0.2684806952479541 | -0.06637943675627654
56 | -0.06903749555330813 | 1.950063432561861e-05 | -0.03221996557492904 | 0.03717822745001224 | -0.1030870607231812 | 0.131073695262056 | -0.03479214761515696 | -0.01701733954113021 | -0.2121616751864232 | -0.1467759461365125 | -0.2258167115925329 | -0.0008903982673901001 | 0.2097748380261692 | -0.4589485853225193
57 | 0.03505497109767054 | -0.04011735044523233 | -0.01353120098717684 | 0.1210810832949526 | 0.1166110974506871 | 0.0136880655221386 | 0.07500285351654572 | 0.04384811633299322 | 0.03249505339262434 | 0.1531185704275566 | -0.07522632523443795 | 0.1148197738979414 | 0.2298455979238173 | -0.3456578617466295
58 | 0.1683901443243216 | 0.1986274192055624 | -0.1244819310064213 | 0.05097052694220579 | -0.1607852765626591 | -0.01840658193627875 | 0.19967309966136 | -0.03389732672148078 | -0.0784631082347928 | 0.2126069569390929 | -0.06325101513536381 | 0.04286793079013336 | -0.07521666599764668 | -0.2819214137336417