I have been struggling with this code for a long time now, so thought I should reach out to your guys out there. What I am trying to achieve is in a Pivot (cross) table there is district wise & day wise % Online Sales and the following color code is to be applied on the same -
1. If value in less than 25%, font color must be Red.
2. If value in more than 95%, font color must be Green.
3. Anything in between the above 2 limits must be Red if lesser than the previous day or else Green if higher than the previous day.
Code I could write is as follows, but it is throwing an error -