(Pivot table) Change background color if value > target in 3 out of 6 months
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.
