• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Matching Dates and Highlighting Rows

B

brawnystaff

New Member
I have an Excel 2010 workbook with two Sheets in it.


Sheet 1 has a "date from" column and a "date through" column along with ID and name columns. Sheet 2 has simply a "date" column that has a single date along with an ID and name. I need a macro that highlights rows in both Sheets when the date in Sheet 2 is equal to or between the "date from" and "date through" in Sheet 1 for each unique ID.


Link are before and after workbooks of what I am looking at/for. Any ideas for a macro to accomplish this? Thanks.


https://dl.dropbox.com/u/25448773/Before.xlsx


https://dl.dropbox.com/u/25448773/After.xlsx
 
Hi ,


Given the following from and through dates :

[pre]
Code: 
7/1/2009	7/1/2013
[/pre]
all the dates that you have given will fall within the above range of dates.


Is this a typographical error ?


Narayan
 
Actually, one cells did have a wrong date, but I fixed it. (said 7/1/2013, now says 7/15/2009). Anyway, each workbook has two sheets in it. I am trying to compare Sheet 2 to Sheet 1 for each ID column, if Date (column A) matches the date range in columns A through B, then I need both rows highlighted in each sheet.
 
Hi ,


Can you check out the file here ?


https://www.dropbox.com/s/hx21aebx1rxkupr/After_1.xlsx


I have not done the highlighting , but the results of the formulae can be used to highlight the relevant rows.


Narayan
 
You must log in or register to reply here.
Back
Top