Please assist. Am I able to change the colour to one or two colour gradient once in the Custom Format Cell option of pivot table? I see the options are disabled. Is it maybe a setting that I need to check?
Matlotlo, I found the following Help link that I think may be on the right track, but I am not sure, have a look and see if that may do what you want or not. This option will actually give you a much larger gradient I think than just two. May need a screenshot etc. of exactly what you are doing in order to provide something better here.
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.