If I understand well your board, all of your Sales Percentages fall between the 20TH and the 30TH values?
You are trying to color the Sales Percentages column only, based on their results?
I am sorry if I missed to explain the scenario clearly,
Based on the Sales Percentages I have to highlight the "Values", PFA screenshot for the same,
I guess it will give some clear picture. . .
In the first row, sales percentage is falling in between 30th Value and 40th Value, so 30th value should be highlighted,
In the second row, sales percentage is falling in between 20th Value and 30th Value, so 20th value should be highlighted. . .
Capture.JPG 197.8 KB