Forum Discussion
Conditional Format for column cells that fit within a threshold
N/A
While I'm on the subject....your question poses some questions of its own. Presumably those values lower in the sequence are all smaller, which means there could be any number of cells that could be included from that lower range. Do you want the "N largest" of those remaining smaller values, or the largest number of the remaining smaller values? Does it matter? Perhaps the easiest way to get as close as possible to that stated limit would be to take the remaining values from the bottom of the available range. Doing it from the next lowest would still be getting the "bigger pieces."
I want the numbers that come next in the sequence, in the attached spreadsheet you can see that each $ value has a score attached, I want the next lowest numbers with the highest scores to be highlighted as fitting in the threshold