Forum Discussion
conditional formatting
I'm trying to highlight the lowest 10 scores out of 20 for my golf handicap. I used conditional formatting rule "Format only top or bottom values" and I used Bottom with the value 10 as the ranking v...
Using the same logic as in previous post it could be done without helper columns applying the formula to the rule like
=D4*(1+COLUMN(D4)/10000000000)<=AGGREGATE(15,6,$D4:$W4*(1+COLUMN($D4:$W4)/10000000000),10)
I'm not sure what shall be the logic if blank cells, thus ignored that case.
Second sheet in attached file.
I think he deleted his account? Null Null?
Anyway, I've learnt someone new from that formula so thanks for that. That's very clever.
Philip, null null appears for the users who have no first/last name in AAD account, more about that is here https://techcommunity.microsoft.com/t5/Community-Ideas/null-null-Members/idi-p/175450
Thanks for the positive feedback