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:

This post contains some responses to questions that I have been asked by various people over the last few years. In most cases, I have also posted the information on relevant online community forums such as moodle.org. I hope that you find this useful. Stephen Digby