Excel Conditional Formatting: Colour cells containing weekend dates

  • In excel, highlight the cell range containing the dates.
  • Format - conditional formatting
  • Formula is  =(OR(WEEKDAY(A1)=1, WEEKDAY(A1)=7)

No comments: