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.
