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

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.

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

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Shoe56" wrote:
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.