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
Copy/paste no longer working in Excel
Jon Firooz in Excel on
76 Replies
changing Date format in a pivot table
ahmad ali in Excel on
12 Replies
runtime error 1004 : Method range of object - 'Global' failed
Lorenzo Kim in Excel on
16 Replies
INDEX & MATCH interrupted by Inconsistent Dates
shade206 in Excel on
18 Replies
Need to extract values from named cells (Get and Transform)
JEMagnussen in Excel on
23 Replies
!SPILL error with SUMIFS formula
Dzung Vu in Excel on
18 Replies