1 of 1 people found this helpful
You can temporarily modify your formula to bucket the required data and assign a color, and then set it back to what it was. In the below, I commented out the 50-70 ranges and let the value get assigned to the 70-80 range and set the color. You may need to repeat it for all the ranges possible.
That's super helpful, if not ideal. I wonder if there's an idea out there that addresses this. It must be a common problem people are facing.
Yes, many of us face this problem, but we have a solution, whether it's ideal or not. Anyway, appreciate if you can close this thread now.