For example, if you have dates in the range C4:C10, and want to weekend dates, select the range C4:C10 and create a new conditional formatting rule that uses this formula: Note: it’s important that CF formulas be entered relative to the “active cell” in the selection, which is assumed to be C5 in this case. Once you save the rule, you’ll see all dates that are a Saturday or a Sunday highlighted by your rule.
Highlighting the entire row
If you want to highlight the entire row, apply the conditional formatting rule to all columns in the table and lock the date column:
Dave Bruns
Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.
