My fellow PowerPoint MVP, Glenna Shaw has written a great tutorial on how to create Excel table heat maps.
Generally, we think of “heat maps” as geographical, shading in countries, states or other regions to indicate relative values. But heat maps can actually much more easily be applied to Excel tables through conditional formatting—rendering a “referanceable” table into a “glanceable” visualization.
