I have some dates from B5:B9 and I want to highlight the entire row in yellow if they are within a month and not complete, but nothing happens when I apply this rule:

<code>=AND(MONTH(B5:B9)=MONTH(TODAY()), D5:D9<>"Y")</code>