| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional formatting excluding weekends and holidays
I am trying to creat a chart where you put a start date and a finish
date in and the chart will colour some squares to the right. I can do all of that but it overcolours the weekends and counts them as days. How can I set it that the squares will only colour weekdays only and not weekends or holidays and not count them as days. Regards Andrew |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting to exclude weekends and Bank Holidays | Excel Worksheet Functions | |||
| Calculate A Date Excluding Weekends And Holidays | New Users to Excel | |||
| Workday With Weekends Excluding Holidays | Excel Worksheet Functions | |||
| Rename Worksheets excluding Weekends and Holidays | Excel Programming | |||
| Formula - Excluding weekends & holidays | Excel Worksheet Functions | |||
Threaded Mode
