Spreadsheet: 734961d1622622694-conditional-format-based-on-subtotal-condition-format-based-on-subtotal
Sheet: YEARLY DATA

YEAR | CHANNEL | Salesman | Opening O/s | Sales | Sales % | Total Coll | Collection % | Closing O/s
18-19 | B/S | SHAFI SHAIKH | 103662382 | 80837259 |  | 26161589
18-19 | B/S | BHIMA KANAKI | 108259226 | 23911783 |  | 57562025
18-19 | B/S | JAYSING GUNEWALE | 92796704 | 18857752 |  | 108604655
18-19 | B/S | KISAN KONDA | 39520314 | 67938041 |  | 86549882
18-19 | B/S | PRAKASH WADHWANI | 2222489 | 77499529 |  | 12717961
18-19 | P/R | SHAFI SHAIKH | 45882407 | 55027438 |  | 26039566
18-19 | P/R | BHIMA KANAKI | 69374458 | 84453041 |  | 112032552
18-19 | P/R | JAYSING GUNEWALE | 75587838 | 31070657 |  | 103298907
18-19 | P/R | KISAN KONDA | 102691728 | 6954371 |  | 34292106
18-19 | P/R | PRAKASH WADHWANI | 43450428 | 109818864 |  | 8732164
18-19 | W/S | SHAFI SHAIKH | 87227627 | 48789936 |  | 38637976
18-19 | W/S | BHIMA KANAKI | 28569470 | 41416268 |  | 70925441
18-19 | W/S | JAYSING GUNEWALE | 90801021 | 16629961 |  | 5440529
18-19 | W/S | KISAN KONDA | 83659196 | 81797124 |  | 36362196
18-19 | W/S | PRAKASH WADHWANI | 109951474 | 8450603 |  | 88239422
18-19 | OVER ALL | KISAN KONDA | 112211848 | 17001904 |  | 69575100
18-19 | OVER ALL | SHAFI SHAIKH | 15595234 | 18154223 |  | 37433051
18-19 | OVER ALL | JAYSING GUNEWALE | 108092606 | 44577437 |  | 59088005
18-19 | OVER ALL | PRAKASH WADHWANI | 93999082 | 55058301 |  | 100655657
18-19 | OVER ALL | BHIMA KANAKI | 39977509 | 44266536 |  | 39894789
19-20 | B/S | SHAFI SHAIKH | 40624409 | 65185617 |  | 92333382
19-20 | B/S | BHIMA KANAKI | 896299 | 111865482 |  | 5421030
19-20 | B/S | JAYSING GUNEWALE | 98408073 | 59210935 |  | 12303090
19-20 | B/S | KISAN KONDA | 122352940 | 118680108 |  | 5729480
19-20 | B/S | PRAKASH WADHWANI | 2439679 | 45338848 |  | 5253667
19-20 | P/R | SHAFI SHAIKH | 38572145 | 82174157 |  | 27520023
19-20 | P/R | BHIMA KANAKI | 58423389 | 6263380 |  | 93482535
19-20 | P/R | JAYSING GUNEWALE | 69298995 | 78337187 |  | 36402397
19-20 | P/R | KISAN KONDA | 100390117 | 59080864 |  | 109037647
19-20 | P/R | PRAKASH WADHWANI | 49814726 | 10166307 |  | 33537840
19-20 | W/S | SHAFI SHAIKH | 68665985 | 2902403 |  | 110200214
19-20 | W/S | BHIMA KANAKI | 108985768 | 36928586 |  | 25934182
19-20 | W/S | JAYSING GUNEWALE | 42920779 | 102218396 |  | 56168416
19-20 | W/S | KISAN KONDA | 74245840 | 38196045 |  | 80283510
19-20 | W/S | PRAKASH WADHWANI | 43417257 | 26527787 |  | 21798276
19-20 | OVER ALL | KISAN KONDA | 106118228 | 15062072 |  | 46222843
19-20 | OVER ALL | SHAFI SHAIKH | 55821196 | 99670048 |  | 29327051
19-20 | OVER ALL | JAYSING GUNEWALE | 37994705 | 13509183 |  | 73568469
19-20 | OVER ALL | PRAKASH WADHWANI | 83673141 | 2072756 |  | 38779338
19-20 | OVER ALL | BHIMA KANAKI | 29734781 | 83426394 |  | 54333873
20-21 | B/S | SHAFI SHAIKH | 70245398 | 52862361 |  | 82572340
20-21 | B/S | BHIMA KANAKI | 92117713 | 98729048 |  | 92635773
20-21 | B/S | JAYSING GUNEWALE | 59799240 | 58905355 |  | 121235992
20-21 | B/S | KISAN KONDA | 41839139 | 92905912 |  | 28601351
20-21 | B/S | PRAKASH WADHWANI | 114046218 | 55789832 |  | 13250066
20-21 | P/R | SHAFI SHAIKH | 90884406 | 48801603 |  | 92298120
20-21 | P/R | BHIMA KANAKI | 57663480 | 39351431 |  | 40890474
20-21 | P/R | JAYSING GUNEWALE | 15069530 | 40823362 |  | 57053775
20-21 | P/R | KISAN KONDA | 39347591 | 80747303 |  | 45900752
20-21 | P/R | PRAKASH WADHWANI | 37823208 | 13747009 |  | 11527058
20-21 | W/S | SHAFI SHAIKH | 112155695 | 89031236 |  | 2218424
20-21 | W/S | BHIMA KANAKI | 47335124 | 71149266 |  | 99839859
20-21 | W/S | JAYSING GUNEWALE | 116449380 | 33821136 |  | 71348231
20-21 | W/S | KISAN KONDA | 36485670 | 24431020 |  | 79685323
20-21 | W/S | PRAKASH WADHWANI | 33162521 | 48679851 |  | 42070307
20-21 | OVER ALL | KISAN KONDA | 2183188 | 75005929 |  | 11043604
20-21 | OVER ALL | SHAFI SHAIKH | 52751939 | 10488051 |  | 35749956
20-21 | OVER ALL | JAYSING GUNEWALE | 26944612 | 54667360 |  | 121723874
20-21 | OVER ALL | PRAKASH WADHWANI | 24200444 | 93133026 |  | 56227549
20-21 | OVER ALL | BHIMA KANAKI | 85435379 | 22398465 |  | 31672256
 |  |  | I Want to Conditional Format on Subtotal Based
 |  | When Collection % is going Greater Than Subtotal % then Icon is
 |  | When Collection % is going Nearby  Subtotal % then Icon is
 |  | When Collection % is going Less Than Subtotal % then Icon is