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!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.