Use Conditional Formatting for calendar that highlights workweeks of project dates.

Hi,
I think this should work but it doesn't. Any ideas?
=AND($B4>=D$2,$C4<=D$3)

Should look like this
Excel Conditional Formatting.png

Thanks,

Thanks for responding to my post. Attached is the worksheet.

I figured I out, solved. The trick was to separate the logic out of the conditional formatting and then to use a logic function to set up the right condition in each cell. The logic function ORs 3 conditions, 1) testing for dates that Start within a workweek, 2) dates that Span the workweek, and 3) dates that End within a workweek. Attached worksheet, the first section shows the logic function without the conditional formatting, the second section shows the conditional formatting applied. Hope this helps somebody else.

Bob