Conditional Formatting with 3 conditions

[slam]

I have several layers of conditional formatting to apply to date columns, and I've got most working, but am stuck on this one

If A2 is not blank, and E2 is in the past, and F2 is blank, highlight E2 red

Any help would be greatly appreciated.

Thanks

 

[ExcelToDAX]

How about:

=IF(AND(ISBLANK(A2)=FALSE,E2<TODAY(),ISBLANK(F2)),1,0)

 

[Fluff]

Another option is the "blank" cells contain a formula

=and(a2<>"",e2<today(),f2="")

 

[slam]

Thank you both for taking the time to help. Used the first solution, as I don't have any formulas, but good to see that option too.

 

[Fluff]

Glad we could help & thanks for the feedback.