Hello!
I have a list of start and end dates, and I want to shade all data in that row which contain similar start/end dates.
Have attached my excel, column A to D contain the raw data. Column G-J is how I want the data to look like without having to do it manually.
Is it possible?
Thank you!
Use this formula:
=$C2-$B2<5
Then modify this VBA to fill it down:
http://www.excelforum.com/showthread...=1#post2786028
Last edited by dip11; 06-19-2012 at 06:25 AM.
=$C2-$B2<5 will return FALSE or TRUE depending on the value of B2, not on the difference between B2 and C2
You should use parenthesis
Please Login or Register to view this content.
Hi Dip11 & Pepe Le Mokko,
Thanks for the links and tips, shall try my best to work it out with my limited excel/VBA skills! :D
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks