With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Wednesday, February 14, 2018
yogi_Conditionally Format Top 5 Values In Range F5:AM5
question by: Anna Bayliss https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/iOOUWi1WDZE;context-place=forum/docs Conditional formatting top 5 values
Please can you advise formula to highlight top 5 values in a range on Google sheet
My data range is F5:AM5
I have tried various formulas from online forum's and the google sheet conditional formatting doesn't have the preset of 'Format only top or bottom ranked values' as is in Excel.