software

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 quot;bold
outquot; and change the font color of every entry that is either a Saturday or
Sunday?Kind Regards,BhupinderUse Conditional Formatting:Pull-down:
Format gt; Conditional Formatting and select formula is and enter:
=(WEEKDAY(A1,2)gt;5)
--
Gary's Studentquot;Bhupinder Rayatquot; wrote:

gt; Hi all,
gt;
gt; I have a column of chronological dates in the Custom format ddd dd (i.e. Wed
gt; 11), by which the date in the first cell of the column is entered and each
gt; corresponding cell is a formula of the above date plus 1.
gt;
gt; e.g A1 - Wed 11
gt; A2 - =A1 1 (Thu 12)
gt; A3 - =A2 1 (Fri 13)
gt;
gt; How can I get excel (maybe by using conditional formatting or VBA) to quot;bold
gt; outquot; and change the font color of every entry that is either a Saturday or
gt; Sunday?
gt;
gt;
gt; Kind Regards,
gt;
gt;
gt; Bhupinder
gt;

Try this:
Select the cells
Formatgt;Conditional Format
Formula is: =WEEKDAY(B1,2)gt;5
Click the [Format...] button and set the desired format
Click the [OK] button

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;Bhupinder Rayatquot; wrote:

gt; Hi all,
gt;
gt; I have a column of chronological dates in the Custom format ddd dd (i.e. Wed
gt; 11), by which the date in the first cell of the column is entered and each
gt; corresponding cell is a formula of the above date plus 1.
gt;
gt; e.g A1 - Wed 11
gt; A2 - =A1 1 (Thu 12)
gt; A3 - =A2 1 (Fri 13)
gt;
gt; How can I get excel (maybe by using conditional formatting or VBA) to quot;bold
gt; outquot; and change the font color of every entry that is either a Saturday or
gt; Sunday?
gt;
gt;
gt; Kind Regards,
gt;
gt;
gt; Bhupinder
gt;

Gary / Ron,

Works like a charm! Thank you....Bhupinder Rayat

quot;Ron Coderrequot; wrote:

gt; Try this:
gt; Select the cells
gt; Formatgt;Conditional Format
gt; Formula is: =WEEKDAY(B1,2)gt;5
gt; Click the [Format...] button and set the desired format
gt; Click the [OK] button
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;Bhupinder Rayatquot; wrote:
gt;
gt; gt; Hi all,
gt; gt;
gt; gt; I have a column of chronological dates in the Custom format ddd dd (i.e. Wed
gt; gt; 11), by which the date in the first cell of the column is entered and each
gt; gt; corresponding cell is a formula of the above date plus 1.
gt; gt;
gt; gt; e.g A1 - Wed 11
gt; gt; A2 - =A1 1 (Thu 12)
gt; gt; A3 - =A2 1 (Fri 13)
gt; gt;
gt; gt; How can I get excel (maybe by using conditional formatting or VBA) to quot;bold
gt; gt; outquot; and change the font color of every entry that is either a Saturday or
gt; gt; Sunday?
gt; gt;
gt; gt;
gt; gt; Kind Regards,
gt; gt;
gt; gt;
gt; gt; Bhupinder
gt; gt;