Recent Posts

I've always admired the way GitHub presents your contribution activity with a slick, heatmap-styled tracker. Let's create our own version in Excel. Contents: 1. Data Setup 2. Formula 3. Formatting 3.1. Conditional Formatting 3.2. Cell Size 3.3. Hide Text Values 3.4. Cell Border 3.5. Adding Month/Day Names 4. Adjust for Different Start Days (Non-Monday) Habit Tracker & Calendar Heat Map There are a two main parts that we need to convey with our heatmap. First w