Change the text format for weekend days (Sat, Sun)

[Bhupinder Rayat]

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

 

[Gary''s Student]

Use Conditional Formatting:


Pull-down:
Format > Conditional Formatting and select formula is and enter:
=(WEEKDAY(A1,2)>5)

 

[Ron Coderre]

Try this:
Select the cells
Format>Conditional 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]

Gary / Ron,

Works like a charm! Thank you....


Bhupinder Rayat

Try this:
Select the cells
Format>Conditional 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

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