Build your own Heatmap in Excel

Conditional formatting is a great tool in Excel.  It sounds fancy, but if you’ve ever color-coded anything before, you know how conditional formatting works.  Given the rules you provide Excel, it will format things accordingly. Many conditional formatting features have been added to recent editions of Excel.  My favorite is the Color Scale.  This feature allows you to look […]