Problem 1 - Holidays that fall on Sun/Mon/Tue shift pickup day to Wednesday. There are only 5 months with Holidays that impact pickups, but Red Holidays are working and the Yellow/Blue fill is not. PARTIALLY WORKING, will update
Problem 2 - If there isn't a date, there should be no fill color in those cells (APRIL 2026 for example) - FIXED/SOLVED pending other changes
Last edited by mebert80; 04-21-2024 at 02:10 PM.
For problem 2:
=AND(O6<>"",K6="A")
Problem 1: please give at least ONE worked example. The CF for yellow and blue is not designed to take holidays into account, so in what way are they 'not working'?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thanks for the help with Problem 2!! I keep finding other issues, but I will get them cleaned up (or try to) as I fix these other problems. As for Problem 1, I guess the best example I can give you is on the 2026 September month, cell W25 is a Holiday and X25 is highlighted Yellow, but i need it to be Y25 and Blue, and X24 should be highlighted Yellow.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks