| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to link an Excel file due date to Outlook calendar date? | New Users to Excel | |||
| alarm a date in excel to outlook calendar | Excel Discussion (Misc queries) | |||
| calendar option to choose a date in excel | Excel Discussion (Misc queries) | |||
| pick date from calendar in excel | Excel Worksheet Functions | |||
| Set a cell to have a pop-up calendar for date selection in Excel? | Excel Worksheet Functions | |||
Linear Mode
