Hi

I am stuck up with this problem. Scenario is, I have range of date values in columns A and B of excel. I have a criteria range being another set of date values. The condition to match is that the date values in corresponding rows of A and B must be inbetween any of the values specified by the criteria range. I want to color those corresponding row values of A and B which is in between any of criteria range values. Can it be done using Advanced filter in one go or should I go for AutoFilter to loop through all the criteria values and input date values of A and B respectively

Any help in this regard is greatly appreciated

Amar