I have a spreadsheet that contains a calender at the top. Pretty much every day from sept 1 to may 1. Column A contains projects I'm working on. I want to map out when i'm going to do each job and how long it should take.
My question is how do I make a conditional fomat such that the weekend days are highlighted in a different color? Basicaly, how do i get excel to recogonize a weekend from a weekday.
My question is how do I make a conditional fomat such that the weekend days are highlighted in a different color? Basicaly, how do i get excel to recogonize a weekend from a weekday.