Highlight WEEKENDS or WEEKDAYS using conditional Formatting

 Steps: –

1. Select the entire Date column, without header (Do not select the 1^st heading row)
2. Go to Home Tab, and then Conditional Formatting
3. Click on New Rule
4. 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)
5. Click on Format
6. Select the kind of formatting you need to highlight the weekends
7. Click Ok and then Ok again