Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shade date headers, if Weekends or Holidays
Sheet1 with Column Date headers, for the next 18 Months.
Sheet2 with Holidays Dates in Column A Questions : 1. How do I shade the headers with VBA for Weekends & Holidays ? 2. How do I, on Button-Click, Toggle Hide / Unhide the columns with shaded headers Thank you for your help, Celeste |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shade date headers, if Weekends or Holidays
First, you're going to have to create a named range for HOLIDAYS on Sheet2.
If you have a header in Sheet2!A1 try this =OFFSET(Sheet2!A1,1,0,COUNT(Sheet2!$A:$A)-1,1) If there is no header, use this =OFFSET(Sheet2!A1,0,0,COUNT(Sheet2!$A:$A),1) For the conditional format, put this =OR(WEEKDAY(A1,2)=6,ISNUMBER(VLOOKUP(A1,HOLIDAYS, 1,FALSE))) -- HTH, Barb Reinhardt "u473" wrote: Sheet1 with Column Date headers, for the next 18 Months. Sheet2 with Holidays Dates in Column A Questions : 1. How do I shade the headers with VBA for Weekends & Holidays ? 2. How do I, on Button-Click, Toggle Hide / Unhide the columns with shaded headers Thank you for your help, Celeste |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for adding days to a date excluding weekends and holidays? | Excel Discussion (Misc queries) | |||
Date/Time Difference Excluding Weekends & Holidays | Excel Worksheet Functions | |||
Calculate A Date Excluding Weekends And Holidays | New Users to Excel | |||
Calculate End Date (excluding weekends and holidays) | Excel Worksheet Functions | |||
Calculate A Date Excluding Weekends And Holidays | New Users to Excel |