Forum Discussion
Conditional Format for column cells that fit within a threshold
N/A
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
That link requires you to individually grant access to us. The message below appears when one clicks on it. You need to post a link that grants access to all who click on it,
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
