Thread: Using a calendar in Excel, want to shade date boxes the same
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
  
Posts: 9,221
Default 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.
Reply With QuoteReply With Quote