Excel - Heat Map

Highlighted
Occasional Visitor

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 

0 Replies