Excel Forum



Excel Magic Trick 534: Conditional Formatting for Weekends and Holidays


See how to use the OR and WEEKDAY functions to create a logical true / false formula that will apply formatting to a date when it is the weekend or a holiday.





Got a Question? Ask it Here in the Forum.