You mentioned that you already have a macro on this spreadsheet to pick up
the first date. If you were to run the following macro after you had
completed the selection I think it will do what you want.

Public Sub COLOURCELL()

For Each c In Range("workingdays")
c.Select
If Weekday(ActiveCell.Value) = 1 Or Weekday(ActiveCell.Value) = 7 Then
With Selection.Interior
.ColorIndex = 6
.Pattern = xlSolid
End With
End If
Next c
End Sub

June



"StargateFanFromWork" wrote in message
...
Hope the subject line isn't totally muddy <g.

I have a spreadsheet that is super. The only trouble is that weekends
aren't differentiated from weekdays in any way.

Since the spreadsheet contains a macro for the user to select the starting
date and then the rest of the spreadsheet is then populated for 3 weeks
following that date, Saturday and Sunday always fall on different cells at
any given time. Also, affected cells may say "Saturday" or "Sunday" but
there is actually only a formula in any of them. The only exception is
the
very first cell which is the initial one the macro dumps to. So the first
might read "Friday" if I choose today's date in the prompt box, but all
the
rest of the days of the weeks shown display the dates according to
appropriate variations of this formula:

=IF(A2<"",A2+1,"")

In today's example, this actual formula above displays "Saturday". The
cell
immediately below displays "Sep.17.2005". I'm hoping that since it's the
same type formatting issue, hopefully resolving cell colouring for the
text
"Saturday" issue will lead me to figure out how to do so for dates that
fall
on weekends.

Is there a way to do this cell colour change under these conditions?

I'm in favour of conditional formatting, but couldn't figure out how to do
so because of the fact above that no actual text is found where all the
Saturdays and Sundays are, only the formula. Tx.! :oD