May 18 2019 07:35 PM
Hi there,
I am trying to heat map the data for a whole year, with keeping in mind the 24 hour period. For eg:
1. I would like to highlight cells with less than or equal to 35 (value) - colour X
2. I would like to highlight cells with more than 35 (value) - colour Y
3. I would like to highlight cells with same value (35 or more) if the situation doesn't change (If at 8:00 clock - the value is 38, the colour would be "y" , but if the value remains the same or increases - then colour would be "Z". If the value goes down - then it would either remain Colour "Y" or "X"
Attaching a file for reference, thanks