Hi All., Need your help with the following macro.. there are Four date and time columns in the attached spreadsheet. Date A1, Date A2, Date B1 and Date B2. The macro I'm looking for should color the entire row if the date and time range of B1 to B2 falls within (or same as) the date and time range of A1 to A2. failing which it should color the row red.
Can you guys help me out on this please.. also can you share the code you are using to get this sorted please.. Many Thanks., kishore M I -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using "remove me" as the subject.
Date Range Diff color.xls
Description: MS-Excel spreadsheet
