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

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

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

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