To highlight Weekends using conditional formatting, is quite simple. You just need to enter 1 formula!

 Steps: –

  1. Select the entire Date column, without header (Do not select the 1st 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