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

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

Originally Posted by jwright650

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

I had same problem for some reason. Couldn't upload unless I zipped it. I'm not very familiar with conditional formating.

But its SAP (MRP program) that generates these reports and you can save them in xls. So I will have a raw data like that I have to start to manipulate. Currently people at work will arrange the columns, use their judgment and then highlight certain ranges in red, orange and green. etc. And then it gives you overall picture and you have to sort out some problems with some parts, suppliers etc.

I'm pretty sure its macros what I'm after. I would appreciate the help.


Cheers

Originally Posted by jwright650

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

Thx for emailing me the xls. Its spot on as far as the result. But can I achieve the same result with macro? The result is excatly what i needed.