Ranking across a dimension consisting of multiple list items
I'm trying to create a sort of 'heat map' based on percentages within columns in a table.
Basically, what I'm trying to do is transform this table into something where each column would be separate from the other in terms of conditional formatting.
For example, 'training period' would have 'problems with solute/water clearance' and 'peritoneal leaks/hernia' as the deepest color red because they’re the highest percentages within that column and then everything from there would be gradually shaded less and less depending on what the percentage is.
The problem is, I want this to happen within each column - not across the entire table. I have been trying to formulate some type of rank formula but each column is representative of a different member in a list so it's a bit difficult.
Has anyone performed something similar?
Any type of help would be much appreciated! Thanks!