Using a calendar in Excel, want to shade date boxes the same

S

Shoe56

Sunday and Saturday when shading the box are not the same color. How do I
make it so all boxes can be shaded the same on a ready made calendar in Excel
2003.
 
M

Max

One interp & thought would be to use conditional formatting,
apply the CF formulas as, for example:

assuming A1 is the active cell in the CF range
and A1/the CF range contains real dates

Condition 1:
Formula Is:
=TEXT(A1,"ddd")="Sat"
Format as desired

Condition 2:
Formala Is:
=TEXT(A1,"ddd")="Sun"
Format as desired
 
Top