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

B

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
 
G

Gary''s Student

Use Conditional Formatting:


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

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
 
B

Bhupinder Rayat

Gary / Ron,

Works like a charm! Thank you....


Bhupinder Rayat

Ron Coderre said:
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 said:
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
Click to expand...
Click to expand...
 
Top