Forum Discussion
Conditional Formatting Non-work Days
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...
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...
Thank you for the quick response. I do apologize for initial lack of information, but your answer was what I was looking for and I learned something new. I never knew there was a "Switch" formula. Again, thanks a million.
Glad you have it working as expected & Thanks for providing feedback
FYI the https://support.microsoft.com/en-us/office/switch-function-47ab33c0-28ce-4530-8a45-d532ec4aa25e is available with Excel >/= 2019
