(Pivot table) Change background color if value > target in 3 out of 6 months

btrinh — Sat, 16 Nov 2024 02:22:56 GMT

Hello all,

I hope someone could help me with this problem.

I have a pivot table, with value calculated by this formula ():

if( count([Group])>10 and avg([Actual Value])>avg([Target Value]), avg([Actual Value]) )

If the value in the pivot is not null in 3 out of 6 months, I need to highlight the cells like this: (can't change background color here, so I had to change text color)

Group	Jul-19	Aug-19	Sep-19	Oct-19	Nov-19	Dec-19
A			43	28	25
B		37			41	47
C					44	36
D		41

Looking forward to your help! If my question is not clear enough, please kindly let me know.

topic (Pivot table) Change background color if value > target in 3 out of 6 months in App Development

(Pivot table) Change background color if value > target in 3 out of 6 months