Trying to set up a time card at work in Excel, dates go to the left side Worksheet: Fri 1/1/11 Sat 1/2/11 Sun 1/11/11 and so on. I want to starve the rows with the weekend dates: Fri 1/1/11 Is this a clear way to use conditional formatting? Of course, to determine the day of the week, Depending on the days of the week, you may need to modify the second parameter if you have more about the
Sat 1/2/11 Sun 1/3 / 11
WEEKDAY function, such as:
= WEEKDAY ($ A1,2) & gt; 5 WEEKDAY function (and other parameters) Can find information.
Comments
Post a Comment