SUMPRODUCT issue

[ant2210]

Hi Guys,

Trying to figure this out with no luck. I am using the following formula to highlight date ranges that overlap using conditional formatting.

=SUMPRODUCT(($D5<=$E$5:$E$101)*($E5>=$D$5:$D$101))>1

What I am trying to do is make it so it only checks and highlights the dates that occur after today.

I hope that makes sense and that someone can help with this.

Thanks in advance.

Ant

 

[Joe4]

Welcome to the Board!

Without knowing what your data in cells D5, E5 and in columns D and E look like, it is hard to help you out.