Spreadsheet: 862818d1710415184-automate-conditional-format-on-a-column-based-on-the-run-rate-conditional-format
Sheet: Sheet1

 | Output
 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
 | 2025-01-27 00:00:00 | 2025-01-28 00:00:00 | 2025-01-29 00:00:00 | 2025-01-30 00:00:00 | 2025-01-31 00:00:00 | 2025-02-01 00:00:00 | 2025-02-02 00:00:00
S1 | 76.02017417631929 | 80.69085496971609 | 70.7549371817262 | 69.84548243990831 | 62.07086943836461 | 61.19869270283538 | 0
S2 | 58.47705705870715 | 66.7786385956271 | 50.94355477084286 | 47.49492805913766 | 56.67340253068073 | 52.85341642517601 | 0
S3 | 67.24861561751322 | 75.1259684200805 | 50.94355477084286 | 50.28874735673398 | 48.57720216915491 | 50.07165766595622 | 0
[NAME] | 58.47705705870715 | 69.56108187044491 | 59.43414723265001 | 50.28874735673398 | 48.57720216915491 | 52.85341642517601 | 0
S5 | 64.32476276457786 | 75.1259684200805 | 59.43414723265001 | 53.08256665433031 | 56.67340253068073 | 50.07165766595622 | 0
S6 | 70.17246847044858 | 86.25574151935167 | 59.43414723265001 | 69.84548243990831 | 62.07086943836461 | 61.19869270283538 | 0
S7 | 87.71558558806072 | 69.56108187044491 | 76.4153321562643 | 78.22694033269731 | 80.96200361525818 | 66.76221022127497 | 0
S8 | 105.2587027056729 | 97.38551461862286 | 99.05691205441669 | 103.3713140110643 | 107.9493381536776 | 83.4527627765937 | 0
S9 | 137.4210840879618 | 136.339720466072 | 147.1702693379905 | 131.3095069870276 | 140.3341395997809 | 122.3973854056708 | 0
S10 | 154.9642012055739 | 144.6870502905254 | 161.3212567743358 | 153.6600613677983 | 153.8278068689906 | 139.0879379609895 | 0
S11 | 134.4972312350264 | 147.4694935653432 | 166.9816517488738 | 136.8971455822203 | 148.4303399613067 | 155.7784905163082 | 0
S12 | 163.73575976438 | 144.6870502905254 | 169.8118492361429 | 167.6291578557799 | 140.3341395997809 | 158.560249275528 | 0
S13 | 154.9642012055739 | 141.9046070157076 | 152.8306643125286 | 176.0106157485689 | 151.1290734151486 | 150.2149729978687 | 0
S14 | 184.2027297349275 | 141.9046070157076 | 155.6608617997976 | 148.0724227726056 | 143.0328730536228 | 158.560249275528 | 0
S15 | 152.0403483526386 | 141.9046070157076 | 158.4910592870667 | 153.6600613677983 | 140.3341395997809 | 152.9967317570885 | 0
S16 | 146.1926426467679 | 136.339720466072 | 144.3400718507214 | 128.5156876894313 | 151.1290734151486 | 152.9967317570885 | 0
S17 | 146.1926426467679 | 130.7748339164364 | 133.0192819016453 | 153.6600613677983 | 143.0328730536228 | 158.560249275528 | 0
S18 | 134.4972312350264 | 133.5572771912542 | 121.6984919525691 | 142.484784177413 | 134.936672692097 | 155.7784905163082 | 0
S19 | 146.1926426467679 | 116.8626175423474 | 133.0192819016453 | 128.5156876894313 | 126.8404723305712 | 144.6514554794291 | 0
S20 | 152.0403483526386 | 122.427504091983 | 141.5098743634524 | 159.247699962991 | 137.6354061459389 | 147.4332142386489 | 0
S21 | 154.9642012055739 | 153.0343801149788 | 150.0004668252595 | 148.0724227726056 | 134.936672692097 | 147.4332142386489 | 0
S22 | 157.8880540585093 | 158.5992666646144 | 150.0004668252595 | 150.866242070202 | 140.3341395997809 | 141.8696967202093 | 0
S23 | 128.6495255291557 | 114.0801742675296 | 130.1890844143762 | 117.340410499046 | 113.3468050613615 | 125.1791441648905 | 0
S24 | 87.71558558806072 | 86.25574151935167 | 90.56631959260953 | 72.63930173750464 | 80.96200361525818 | 89.01628029503328 | 0
Total