conditional formatting of holidays

[daveyc18]

i cant remember how i did it, but basically the formatting only highlights the holidays when the date has passed the previous business day...so remebrance day should be only yellow since its nov 11 and the previous business day is nov 15 (im writing this nov 18 EST)

Holidays:
Rememberance Day	November 11, 2024
Christmas Day	December 25, 2024
Boxing Day	December 26, 2024
New Years Day	January 1, 2025
Family Day	February 17, 2025
Good Friday	April 18, 2025
Victoria Day	May 19, 2025
Canada Day	July 1, 2025
Civic	August 4, 2025
Labour Day	September 2, 2024
Thanksgiving	October 7, 2024

 

[dermie_72]

would using the condition of if if(networkdays(holiday date, today())>1) work?
not 100% sure what you're asking but assumed you want to highlight a cell if the holiday is in the past and has a work day in between???
You didnt have cell references in your example, so used holiday date instead, adjust as required

 

[daveyc18]

would using the condition of if if(networkdays(holiday date, today())>1) work?
not 100% sure what you're asking but assumed you want to highlight a cell if the holiday is in the past and has a work day in between???
You didnt have cell references in your example, so used holiday date instead, adjust as required

I want the holiday to highlight when it has passed as a reminder to update the date to next year so that the previous business day does not factor in holidays