Uploaded May 2018 | Updated September 2026, 1 hour ago
A fun solution to a unique request. My post:
myspreadsheetlab.com/variable-sized-groups-within-each-column-of-data
1) Highlight top x values per column
2) Highlight group green if x % of group numbers are in the top x %
3) Functionality to switch off (1) & (2) above
4) Solution must work with additional columns of data
Conditional formatting in Excel is so powerful and most of the time the rules are easy to create.
A fun solution to a unique request. My post:
myspreadsheetlab.com/variable-sized-groups-within-each-column-of-data
1) Highlight top x values per column
2) Highlight group green if x % of group numbers are in the top x %
3) Functionality to switch off (1) & (2) above
4) Solution must work with additional columns of data
Conditional formatting in Excel is so powerful and most of the time the rules are easy to create.










