Excel weekend date


I'm Using excel 2010, I download a lot of data with dates in
25/09/2013  5  5 5 6
25/09/2013  4 5 6 6
26/09/2013 1 1 2 3
26/09/2013 1 2 2 3

Is there anyway of telling the excel spread sheet  if the date falls on a weekend to change the  colour of the data?

Who is Participating?
FaustulusConnect With a Mentor Commented:
Apply conditional formatting using the 'Use a formula to determine which cells to format' variety with this formula,

Open in new window

A2 should be the first cell in the range you wish to format. The easiest way is to select the entire range you wish to format and Excel (2007 or later) will automatically apply the format to all cells. Else (or additionally) you can modify the AppliesTo range later.
Set the coloring as desired.
jwc1972Author Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.