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

Using conditional formatting, we can use a custom formula to highlight all weekday dates from any date range, letting you visually see...

Using conditional formatting, we can use a custom formula to highlight all weekend dates from any date range, letting you visually see...

To highlight any cell that contains a formula in an Excel workbook, there is a simple conditional formatting formula that can be used....