C
Caroline
I am not even sure if this is possible. I want my field HPU to be
conditionally formatted in my Pivot Chart. However, I don't want it to be
based on itself. I want it to be based on a different AvgHPU that was
calculated earlier. So if the HPU is above the AvgHPU line (which I made just
using a trendline and then hiding the columns since the AvgHPU is the same
for every data point) I want it to be green. If it's within 10% on either
side of the line, I want it to be yellow, and under I want it to be red.
Thanks!
conditionally formatted in my Pivot Chart. However, I don't want it to be
based on itself. I want it to be based on a different AvgHPU that was
calculated earlier. So if the HPU is above the AvgHPU line (which I made just
using a trendline and then hiding the columns since the AvgHPU is the same
for every data point) I want it to be green. If it's within 10% on either
side of the line, I want it to be yellow, and under I want it to be red.
Thanks!