如何使用VBA从开始到结束在Excel中突出显示区域?

I have start and end dates given in Columns A and B. Then I choose a range which I want to look at and generate a row of dates which starts from C1 and can end at any point. I need to highlight a row from start date to end date to the right of given dates. Is there a way to do this? I have no idea where to start...Help, please. For Example,I have start and end dates given in Columns A a