Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / July 2007

Tip: Looking for answers? Try searching our database.

Help with conditional formating

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Lumpjaw - 04 Jul 2007 01:39 GMT
Greetins,

I have a workbook that in column A the cell contents are populated with
dates, let's say A1= 07/01/07, A2=07/02/07, etc.  I would like to do some
conditional formating that examines the date in each row, and if the value
is found to be either "Saturday" or "Sunday" (day of week) the whole
respective row will turn bold black and grayed background.  I already know
you can use the function 'text(a1,"dddd") to get the day, it is the rest I
am lost on.  Thanks for any help.

-lumpjaw
Roger Govier - 04 Jul 2007 01:48 GMT
Hi

Provided you have the Analysis Toolpak loaded, Tools>Addins>Analysis
Toolpak, then
=WEEKDAY(A1,2)>5
will be your test and set the format you require.

Signature

Regards

Roger Govier

> Greetins,
>
[quoted text clipped - 7 lines]
>
> -lumpjaw
T. Valko - 04 Jul 2007 03:37 GMT
No need for the ATP. WEEKDAY is built-in. You were probably thinking about
WORKDAY.

Signature

Biff
Microsoft Excel MVP

> Hi
>
[quoted text clipped - 14 lines]
>>
>> -lumpjaw
Roger Govier - 04 Jul 2007 11:13 GMT
Yep, it was late (early)!!!!! Brain totally fuddled

Signature

Regards

Roger Govier

> No need for the ATP. WEEKDAY is built-in. You were probably thinking
> about WORKDAY.
[quoted text clipped - 18 lines]
>>>
>>> -lumpjaw
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.