Highlighting Weekends can be hard in Excel. So just for fun, we’ll do this in three different ways: we’ll use conditional formatting to highlight the weekend ...
Ever wondered if your could use conditional colouring on Excel sheet tabs? Of course! This post will feature VBA code that will recolour the Worksheet tab based on a ...
This is a follow up post on the final result of last week’s post Table.Join function in Power Query. So basically, we want to get from this To this Only by ...
Simply put, there are two ways to turn Conditional formatting On and Off. The manual way will take you to the Home/Conditional Formatting/Manage Rules… window ...