excel - Conditional formatting based on date -


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

  Sat 1/2/11 Sun 1/3 / 11   

Is this a clear way to use conditional formatting?

Of course, to determine the day of the week, WEEKDAY function, such as:

  = WEEKDAY ($ A1,2) & gt; 5   

Depending on the days of the week, you may need to modify the second parameter if you have more about the WEEKDAY function (and other parameters) Can find information.

Comments