Forum Discussion
Date interval check between columns
So i have dates in a column, B and say there are start and end dates in column D and E, I have to check if date in B1 matches in the interval of D and E, if any date falls in the interval of D and E,...
Highlight B1 if it falls between dates in D1 and E1/D2 and E2/D3 and E3 and continue this checking till D200 and E200.
- Select B1:B200
- Go to Home (tab) > Conditionnal Formatting > New Rule... > Use a formula...:
=IF(ISNUMBER($B1), IF( SUM(($B1>=D$1:D$200)*(B1<=E$1:E$200)), TRUE))
Corresponding sample attached
- THANK YOU SO MUCH, i guess it worked. Can you please help me out with another thing?
So the first, middle and last name is all jumbled up here, like in one worksheet name is "Jack Hunter John", another worksheet name of the same person is "John Jack Hunter", or like "Emma Stone Watson" is written in another sheet as Stone Emma, Is there any way I can match the names based on the strings here like Emma and Jack- Glad I could help. Your other point has nothing to do with this request so please create a new topic with a couple of pictures showing your 2 worksheets + show the expected result
Thanks