When you have a list of dates in Excel it can be useful to know which of those dates are weekends. You can automate a format for weekends using a conditional format.
Tag Archives: Conditional Formats
Show the cells to be removed by Remove Duplicates in Excel
A formula-based Conditional Format
Excel has a Remove Duplicates option in the Data ribbon. It keeps the first item and removes any further items that match.