Wednesday, February 14, 2018

yogi_Conditionally Format Top 5 Values In Range F5:AM5

Google Spreadsheet   Post  #2368

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Feb-14-2018

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.

Thanks!
Anna