Hi All,
I am trying to perform some auto marks from the conditional formatting (1:/, 0:X). I have tried to nested IF but no luck.
What I want to achieve is, select from the dropdown
1. Mon-Fri: / will be marked to Mon-Fri, X to Sat, Sun
2. Mon-Sat: / will be marked to Mon-Sat, X to Sun
3. Mon-Sun: / will be marked to all Mon-Sun
Please find the attachment & any help is greatly appreciated.
Thank-You very much
Bookmarks