Recent Posts

Yes, Excel can find duplicates in several ways. Here's how to highlight, count, and remove them fast.

Turn any photo into an Excel portrait using Python and conditional formatting. Convert an image into a grayscale pixel grid made entirely from spreadsheet cells.

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....