Macro to color highlight dates in certain range. Please help.

Hi. Just few words from me before I will go to the problem as its my first post on these forums. If you want to go straight to helping just skip the first paragraph.

I'm a guy who is generally good with computers but not with hardcore coding. Though if I usually look codes that others have created I then I will understand most of it. I normally prefer to search and search to find my answers rather than asking the same questions that have been asked before. But I got new job now with very limited spare time and I need bit of help. It my first job with actual need for good computer and excel knowledge. I'm now a vendor controller. I would like to do my best to keep this job as the colleagues are very nice Anyway, I will ask help bit by bit in these forums so I can close the threads and mark them solved so others will know it solved my problem and might help them as well. I already see that my job could be a lot less stressful and I can reduce big amount of workload by simply creating some macros. The ones that I can figure out with record macro i will do myself. I just need help with rest of them.

What I need is a macro that would highlight some range of dates in red and some in orange in certain column or columns. We normally work with our data from Friday to Friday.
Let me explain the the ones I need highlighted in red first. I want the macro to highlight all the dates in column U that are in past using the date in cell Z2, for example lets say the date is 28/01/2011. So I want the macro to see the date in Z2 and highlight every date in column U that is before 28/01/2011 (28th inclusive).

Now I would like to have a macro that will highlight some dates in orange. I want the macro to highlight all the dates again in column U that are in 6 days reach using the date in cell AA2, for example lets say the date is 29/01/2011. So I want the macro to see the date in AA2 and highlight every date in column U that is from 29/01/2011 (29th inclusive) to the next 6 days (effectively to the 04/02/2011 inlcusive).

So if I would arrange the dates ascending in column U they would all be highlighted in red till 28th inclusive (Friday), then from 29th (Saturday) onwards till 4th of Feb (inclusive) they would be highlighted in orange. Rest of the dates should remain as normal.

I will attach the excel sheet that is in format I would be actually using. It gives an easy way to test the recommended macro to see if its working. I have deleted some info on some columns so my employer wouldn't mind me uploading it.

I would love to have these 2 macros separately as I will be easier for me to study the code and learn from it.

I hope someone can help me as Im very desperate to get them as quickly as possible to make reduce my workload as there is so much data I need to manipulate and analyze. This would really help me.


Best regards,
Rain

Originally Posted by Cutter

Are you sure you want a macro. Conditional Formatting feature will take care of your requirements.

Correct. See attached<---sorry, it won't let me attach the corrected workbook for some reason

send me an email, and I will send the corrected workbook...something has goofed up with the uploading software, it says that I do not have permission to access this page.

jwright650atAOL.com

Here is what I did to your file in Column U based on a date in Z2

http://www.datapigtechnologies.com/f...rmatexcel.html