Home

Excel - Heat Map

%3CLINGO-SUB%20id%3D%22lingo-sub-612734%22%20slang%3D%22en-US%22%3EExcel%20-%20Heat%20Map%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-612734%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20heat%20map%20the%20data%20for%20a%20whole%20year%2C%20with%20keeping%20in%20mind%20the%2024%20hour%20period.%20For%20eg%3A%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20I%20would%20like%20to%20highlight%20cells%20with%20less%20than%20or%20equal%20to%2035%20(value)%20-%20colour%20X%3C%2FP%3E%3CP%3E2.%20I%20would%20like%20to%20highlight%20cells%20with%20more%20than%2035%20(value)%20-%20colour%20Y%3C%2FP%3E%3CP%3E3.%20I%20would%20like%20to%20highlight%20cells%20with%20same%20value%20(35%20or%20more)%20if%20the%20situation%20doesn't%20change%20(If%20at%208%3A00%20clock%20-%20the%20value%20is%2038%2C%20the%20colour%20would%20be%20%22y%22%20%2C%20but%20if%20the%20value%20remains%20the%20same%20or%20increases%20-%20then%20colour%20would%20be%20%22Z%22.%20If%20the%20value%20goes%20down%20-%20then%20it%20would%20either%20remain%20Colour%20%22Y%22%20or%20%22X%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAttaching%20a%20file%20for%20reference%2C%20thanks%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-612734%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Harsh_Sheth
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 

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies