Hi,
I have a pivot table that shows a percentage value which I want colour-coded based on that value.
I want 100% to be green, 50% to be yellow and 0% to be red, and shades between these values.
What I'm finding is that the conditional formatting is using the max and min values as green and red and in between is yellow rather than the percentage itself.
Capture.JPG
So in this example I expect the values on the left to be various shades of green and on the right light green and maybe yellowish for 59%.
Capture.JPG
Thanks
Bookmarks