Kindly seeking your help on how to add the different conditional formatting like above your dashboard?
I would want to add the different color base on our target, but still have confusion.
eg
for Row1 : if the value is 1 then the cell is yellow if it is lower than 1 the cell is green…
for Row2 : if the value is 2 then the cell is red if it is lower than 2 the cell is green…
Link for my question is here - [High Priority] How to add different targets for pivot table?
Looking forward to your kind reply
Thanks a lot