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 / Word / Mailmerge and Fax / October 2007

Tip: Looking for answers? Try searching our database.

Excel Macro

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
MC - 12 Oct 2007 20:22 GMT
I would like to look for dates in three separate columns that are before a
specific date.  Then I would like to have those dates change to a different
color.  Is this possible to do with a macro and, if so, how?
Peter Jamieson - 12 Oct 2007 21:08 GMT
If you're talking about doing something in Excel, I suggest you ask in an
Excel group.

If you are asking about how to colour the result of date fields in the
result of a Word mail merge, maybe you can spell out the specification? For
example, this is what you say:

>I would like to look for dates in three separate columns that are before a
> specific date.  Then I would like to have those dates change to a
> different
> color.  Is this possible to do with a macro and, if so, how?

Do you mean
a. I want insert dates from three Excel columns
b. For each date
    - if it's before a date I specify (how?), I want it to be displayed in
one colour
     - if it's after a date I specify, I want it to be displayed in another
colour

or what?

(if (b) is about right, you might also consider what you want if the date is
exactly the date you specify)

Signature

Peter Jamieson
http://tips.pjmsn.me.uk

>I would like to look for dates in three separate columns that are before a
> specific date.  Then I would like to have those dates change to a
> different
> color.  Is this possible to do with a macro and, if so, how?
 
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.