Conditional Formatting - blank cell when doing comparison causes formatting

[bmasella]

I am trying to do conditional formatting across an entire row... basically I am saying here if the date in F14 is between these 2 dates give me the formatting. This works fine performing the evaluation of date and doing the proper formatting until I get to a cell that has no date. For example Z$14 is blank which is not between the 2 dates in Stages and Milestones but it formats it anyway. Anyone have any idea how I might make this work?

AND(F$14>='Stages and Milestones'!$E$5, F$14<='Stages and Milestones'!$F$5)

[kev_]

Conditional formatting applies rules in sequence, so you could:
- create another rule that formats row differently if date cell is blank
- then make sure that the new rule is applied after your original rule