Forum Discussion
null null
Sep 01, 2018Copper Contributor
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...
Philip West
Sep 04, 2018Iron Contributor
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.
SergeiBaklan
Sep 04, 2018Diamond Contributor
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