Forum Discussion
Solved
Conditional Formatting Non-work Days
Hello, I'm currently building a new calendar for my company. Basically, we have 3 different shifts that each have their own work days/non work days. Below is the brake down for each shift and thei...
Hi Rusty_Tusty
For this kind of things it's better to share an actual (anonymized) workbook as we have no idea (except dates in G1,H1...) what your setup is. With the below example:
Cond. Format. rule that applies to =$G$2:$R$6:
=SWITCH($A2, "A",WEEKDAY(G$1,2)>5, "B",WEEKDAY(G$1,1)>4, "C",WEEKDAY(G$1,13)>4)Corresponding sample attached...
Some people Search this site and others for existing solutions
You've got 2 options so far. If any of them solves your challenge it would be smart of you to click the Mark as solution link at the bottom of the corresponding post - Thanks in advance