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

  • Thread starter Thread starter Shoe56
  • Start date Start date
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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can you shade one cell 2 different colors? 1
Auto-Format Cell Shading 2
How to make a cell filled w/color more transparent? 1
Partial Shading in Excel 2003 4
Repeated shading of rows?? 8
How do I shade cells that are below Sat or Sun in a calender? 3
cell shading 1
how can I shade alternate rows in Excel 2007? 3

Back
Top