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:

Post a Comment

Comment or Send a Message

You can use this form to send a message OR make a comment as your contribution is NOT published automatically, but sent to Stephen for consideration.

You can select "anonymous" from the drop down menu below if you do not have a google account.