To highlight Weekends using conditional formatting, is quite simple. You just need to enter 1 formula!
Steps: –
- Select the entire Date column, without header (Do not select the 1st heading row)
- Go to Home Tab, and then Conditional Formatting
- Click on New Rule
- Select the last option “Use a formula to determine which cells to format”
Type the below formula in the box below
=WEEKDAY($A2,2)>5
Make sure to add the $ before the A (column part of the cell reference), so that your formatting sticks to only that 1 column. But do not add a $ before 2 (row part of the cell reference) - Click on Format
- Select the kind of formatting you need to highlight the weekends
- Click Ok and then Ok again
To highlight Weekdays, change the formula to =WEEKDAY($A2,2)<=5
You’re done!
You’re welcome!