title: Excel weekends conditional formatting
body: <p>I'm trying to use conditional formatting to highlight only weekends and public holidays using this example <a href="https://www.microsoft.com/en-us/microsoft-365/blog/2013/04/04/using-conditional-formatting-to-highlight-dates-in-excel/#:%7E:text=Highlighting%20holidays&amp;text=Again%2C%20open%20the%20menu%20Conditional,month%20is%20greater%20than%201.&amp;text=Then%2C%20in%20the%20dialog%20box,select%20the%20range%20B4%3AAF11" rel="nofollow noreferrer">https://www.microsoft.com/en-us/microsoft-365/blog/2013/04/04/using-conditional-formatting-to-highlight-dates-in-excel/#:~:text=Highlighting%20holidays&amp;text=Again%2C%20open%20the%20menu%20Conditional,month%20is%20greater%20than%201.&amp;text=Then%2C%20in%20the%20dialog%20box,select%20the%20range%20B4%3AAF11</a>.
  but it won't work.. cells is highlighted but it's not weekends. I'm unable to get holiday to be highlight too.</p>
  <p>Cells is also highlighted based on the absent reason such as AL, MC etc which is working.</p>
  <p><a href="https://i.stack.imgur.com/9GCV5.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/9GCV5.jpg" alt="enter image description here" /></a></p>
  <p><a href="https://i.stack.imgur.com/cyccR.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/cyccR.jpg" alt="enter image description here" /></a></p>
  <p><a href="https://i.stack.imgur.com/BB9bU.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/BB9bU.jpg" alt="enter image description here" /></a></p>