| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change the text format for weekend days (Sat, Sun)
Use Conditional Formatting:
Pull-down: Format Conditional Formatting and select formula is and enter: =(WEEKDAY(A1,2)5) -- Gary's Student "Bhupinder Rayat" wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change the text format for weekend days (Sat, Sun)
Try this:
Select the cells FormatConditional Format Formula is: =WEEKDAY(B1,2)5 Click the [Format...] button and set the desired format Click the [OK] button Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Bhupinder Rayat" wrote: 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change the text format for weekend days (Sat, Sun)
Gary / Ron,
Works like a charm! Thank you.... Bhupinder Rayat "Ron Coderre" wrote: Try this: Select the cells FormatConditional Format Formula is: =WEEKDAY(B1,2)5 Click the [Format...] button and set the desired format Click the [OK] button Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Bhupinder Rayat" wrote: 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 |
| Reply |
| 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) | |||
Linear Mode
