Spreadsheet: 730644d1619803318-formula-to-highlight-the-top-3-5-values-in-a-row-for-eg-in-cells-fa2-to-ge2-ty_-large-function-files
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sales man | TQ-12-3-21 | TQ-15-3-21 | TQ-16-3-21 | TQ-17-3-21 | TQ-18-3-21 | TQ-19-3-21 | TQ-22-3-21 | TQ-23-3-21 | TQ-24-3-21 | TQ-25-3-21 | TQ-26-3-21 | TQ-30-3-21 | TQ-31-3-21 | TQ-1-4-21 | TQ-5-4-21 | TQ-6-4-21 | TQ-7-4-21 | TQ-8-4-21 | TQ-9-4-21 | TQ-12-4-21 | TQ-13-4-21 | TQ-15-4-21 | TQ-16-4-21 | TQ-19-4-21 | [NAME] | TQ-22-4-21 | TQ-23-4-21 | TQ-26-4-21 | TQ-27-4-21 | TQ-28-4-21 | TQ-29-4-21
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | mark | 106676 | 62264 | 76451 | 80160 | 72000 | 122629 | 74675 | 71527 | 30346 | 187328 | 37471 | 78546 | 52205 | 33682 | 45149 | 310825 | 98531 | 115050 | 46763 | 42057 | 61738 | 34375 | 28824 | 52025 | 53444 | 66086 | 65388 | 44347 | 74870 | 56095 | 128921
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 8718 | 10404 | 9375 | 4168 | 5536 | 11797 | 11794 | 4075 | 10338 | 7040 | 12380 | 10407 | 11229 | 8475 | 6292 | 3561 | 5154 | 4385 | 2439 | 7743 | 4482 | 4198 | 7549 | 8336 | 6205 | 7824 | 2935 | 2223 | 5262 | 4020 | 3708
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 26445 | 22773 | 35611 | 16518 | 16083 | 33734 | 17715 | 12411 | 11987 | 25080 | 34031 | 23176 | 29652 | 24901 | 104995 | 57671 | 38624 | 61848 | 58617 | 39732 | 15731 | 233162 | 826346 | 339639 | 194108 | 161082 | 98358 | 71833 | 116201 | 36477 | 20764
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | richards | 41751 | 43993 | 59732 | 105459 | 63499 | 88810 | 29546 | 30964 | 54812 | 102730 | 48875 | 47670 | 31125 | 31204 | 36916 | 26582 | 30708 | 1297800 | 925984 | 214644 | 118069 | 1926800 | 3113908 | 731246 | 855526 | 548933 | 302186 | 258458 | 110715 | 79804 | 56302
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 1427665 | 475436 | 953414 | 365395 | 409208 | 7824602 | 3072899 | 1377341 | 1657594 | 828480 | 499849 | 493898 | 474917 | 786666 | 366612 | 400759 | 596618 | 529594 | 1534378 | 720928 | 559191 | 316853 | 282059 | 1064037 | 1362740 | 509029 | 352104 | 284682 | 362213 | 341078 | 387456
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | martin | 165582 | 144480 | 162087 | 180955 | 119276 | 508829 | 151246 | 160221 | 3097098 | 1124256 | 360493 | 265691 | 195416 | 613919 | 405142 | 542255 | 454587 | 659066 | 246474 | 382214 | 198109 | 166764 | 556562 | 311866 | 287111 | 143565 | 670760 | 558789 | 1040243 | 641469 | 403736
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 48262 | 25849 | 60706 | 71251 | 46501 | 441974 | 131891 | 170535 | 120820 | 235439 | 72125 | 54613 | 105339 | 53783 | 35391 | 35627 | 21018 | 16888 | 326486 | 505937 | 101728 | 128096 | 23314 | 236286 | 22640 | 90264 | 49021 | 47151 | 183672 | 96569 | 194850
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I need a formula to highlight the top 3, 5 values in a row (for eg., in cells FA2 to GE2) by conditional formatting  using large function in excel