Hi,
Put this formula in G5 and fill down:
Code:
=(COUNTIFS($D$5:$D$100,">="&D5,$D$5:$D$100,"<"&E5)+
COUNTIFS($D$5:$D$100,"<"&E5,$E$5:$E$100,">"&D5))<=2
You can also simplify the formula in C5 (if you still want it)
Code:
=COUNTIFS($D$5:$D$24,"<="&A5,$E$5:$E$24,">="&A5)