Spreadsheet: 80254d1280433816-conditional-formatting-a-column-off-of-a-conditionally-formatted-cell-dummybook1
Sheet: Sheet1

year | 2010
 |  |  | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
 |  |  | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019
 |  |  | 0.8548087241476392 | 0.8859726640727521 | 0.2861607688474082 | 0.1468341932876793 | 0.1397211672932759 | 0.3353956090770609 | 0.5079024924084736 | 0.5571456831662926 | 0.9899226622228978 | 0.0127940827259625 | 0.9002831700719531 | 0.473337523564016
 |  |  | 0.1509455714129651 | 0.6962062460655969 | 0.09381924344861314 | 0.4366023865243114 | 0.88111687688159 | 0.01716463500164433 | 0.4298818781929947 | 0.163991977869169 | 0.8908627425946278 | 0.6184089509962565 | 0.6145764240005847 | 0.003914609751771714
 |  |  | 0.8482869380853315 | 0.6947989034506832 | 0.2606457167679785 | 0.7037146807915975 | 0.4516611892308324 | 0.528141122237926 | 0.9397792848541169 | 0.9388446462147151 | 0.4025831957030599 | 0.6335686848389477 | 0.8292028279601311 | 0.4520334437224049
 |  |  | 0.5901595364725409 | 0.3600054507308414 | 0.8639082656306916 | 0.4590274908903651 | 0.4300323853684291 | 0.969473750477404 | 0.2421342264323769 | 0.03746806876150544 | 0.9542282354633531 | 0.8392844120245293 | 0.7263661670980417 | 0.4233055354666737
 |  |  | 0.2454521081250229 | 0.3376159832623937 | 0.3852785751223688 | 0.7260139425586596 | 0.04723388568644626 | 0.8724998023459491 | 0.752343067761551 | 0.1717615495771225 | 0.7141386599825545 | 0.0845796256839455 | 0.2338694698113917 | 0.4203839108752487
 |  |  | 0.8787981048655269 | 0.4066659032595865 | 0.1283632966636405 | 0.7746749430006572 | 0.5557353500939721 | 0.528861042233304 | 0.08393755732215702 | 0.0234056643079843 | 0.2411173564386015 | 0.004680825179806725 | 0.3055636425344366 | 0.1113431329508305
 |  |  | 0.8550871628245926 | 0.9003300412844679 | 0.7558352262600367 | 0.6936164071594466 | 0.04353920011876156 | 0.5528276240274805 | 0.5512561030785559 | 0.4671250915150071 | 0.5646457272871512 | 0.3376785248871255 | 0.102994076064518 | 0.8887015640881013
 |  |  | 0.6150905145220533 | 0.05507294446304023 | 0.9065514252558526 | 0.2405277841195652 | 0.01242753938758501 | 0.9963514939936782 | 0.3405222762838599 | 0.795139548234016 | 0.6787760857845346 | 0.3608686724862951 | 0.2173775895315773 | 0.5396148193723784
 |  |  | 0.06586961700968619 | 0.2010201747035121 | 0.6251774470072302 | 0.0893103056712059 | 0.896205899867746 | 0.835435117149296 | 0.2695691277768133 | 0.2875649169761305 | 0.4039070806184442 | 0.7996291885875331 | 0.5923444377124403 | 0.3515898400212443
 |  |  | 0.7100302841674861 | 0.07228659290479378 | 0.6065738638698903 | 0.1665447792089125 | 0.02887084002703499 | 0.8595946645496142 | 0.1864486296584733 | 0.8233986986919404 | 0.3423546324565234 | 0.6917349583190231 | 0.6892898953991895 | 0.4846860077447128
 |  |  | 0.5732038004549234 | 0.109280429608634 | 0.4865363381512011 | 0.708319979024191 | 0.7742465834587025 | 0.2889728377644154 | 0.5051955520862834 | 0.8093765016378136 | 0.8844042782276345 | 0.8800334539478292 | 0.1737084410866798 | 0.04548902618807471
 |  |  | 0.1242069267708592 | 0.9586883737788767 | 0.3796592101922824 | 0.3182262586816718 | 0.1432946034251916 | 0.4515700514362797 | 0.6383506556122118 | 0.880230618684634 | 0.2486890020904466 | 0.4063869294581073 | 0.3873199169647084 | 0.1774792586468745
 |  |  | 0.8275461330290863 | 0.5322330224513836 | 0.2628290391723322 | 0.965536934304513 | 0.7983984220718332 | 0.6688196641119994 | 0.5945327121869024 | 0.2856241861767801 | 0.2504204097633445 | 0.2140593872256498 | 0.3452175510056601 | 0.671651881533462
 |  |  | 0.8196231383131176 | 0.9718916796014025 | 0.9647822026502777 | 0.6668906455372272 | 0.9541156691355317 | 0.5900530915742928 | 0.999773382922774 | 0.1660477882325428 | 0.4125500524390802 | 0.5696948603965595 | 0.2285757112050917 | 0.5691138046090984
 |  |  | ***Yellow is conditionally formatted to equal B1, and I need which ever year that B1 matches to highlight the entire column yellow (currently orange)