Excel Forum
Similar Content
Add Time Together Limiting by Working Hours and Excluding Weekends and Holidays in Excel
Tutorial: Add two times together to get a future date and time that falls within working hours, excl...
Multiple Conditional Formatting Rules for a Cell in Excel
Tutorial: Apply multiple Conditional Formatting rules to a cell or range in Excel. This allows you ...
Make Complex Formulas for Conditional Formatting in Excel
Tutorial: How to make complex formulas for conditional formatting rules in Excel. This will serve as...



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.