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...
Rusty_Tusty As variant and slightly less advanced. See the attached file?
Thank you for your response this one also works perfectly with what I had in mind. I was initially trying to do this, but I was trying to use the IF function and in one string like the instead of individual formatting. I did play around with your example and realized that I can replace "AND" with "IF" and it still works.
