| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change the text format for weekend days (Sat, Sun)
Hi all,
I have a column of chronological dates in the Custom format ddd dd (i.e. Wed 11), by which the date in the first cell of the column is entered and each corresponding cell is a formula of the above date plus 1. e.g A1 - Wed 11 A2 - =A1+1 (Thu 12) A3 - =A2+1 (Fri 13) How can I get excel (maybe by using conditional formatting or VBA) to "bold out" and change the font color of every entry that is either a Saturday or Sunday? Kind Regards, Bhupinder |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change the format in a excel drop box? | Excel Discussion (Misc queries) | |||
| Convert Text Entry to Date Format | Excel Discussion (Misc queries) | |||
| Hoe to change text format .126 to number format 0.126 | Excel Discussion (Misc queries) | |||
| How do I change macro text with another macro? | Excel Discussion (Misc queries) | |||
| why does currency format change to number format? | Excel Discussion (Misc queries) | |||
Threaded Mode
