Hi,
I've got a spreadsheet with a series of rows and columns that have numbers between 1 and 20 contained within the various cells. I am trying to use conditional formatting to highlight the top 3 values for each row but have thus been unsuccessful in it's execution. I've tried using a variety functions to achieve my desired result but none seem to work (functions such as MAX/MAXA, LARGE and RANK) as all each seem to do is change the formatting for all numbers contained within the row instead of the select 3 I wish to single out. Sorting or filtering the data is not possible for the type of output I am seeking.
Any advice on how to achieve my desired result?
Thanks in advance!
Gordow
I've got a spreadsheet with a series of rows and columns that have numbers between 1 and 20 contained within the various cells. I am trying to use conditional formatting to highlight the top 3 values for each row but have thus been unsuccessful in it's execution. I've tried using a variety functions to achieve my desired result but none seem to work (functions such as MAX/MAXA, LARGE and RANK) as all each seem to do is change the formatting for all numbers contained within the row instead of the select 3 I wish to single out. Sorting or filtering the data is not possible for the type of output I am seeking.
Any advice on how to achieve my desired result?
Thanks in advance!
Gordow