Conditional formatting with AND

[cditski]

Once again I'm back to my new favorite forum with a new question!

On this sheet, Column L is pulling a date from Spreadsheet "0 Revised LOS". Column N4 has a date that is manually entered.

I'm trying to use the conditional formatting to highlight the cell in Column N if Column L's date is today or before and Column N is blank.

It makes sense in my head, but the formula I'm using doesn't want to cooperate.

="IF(AND(L4<=TODAY(),N4=ISBLANK))"

 

[njimack]

=if(and(l4<=today(),n4="")

 

[DRSteele]

We're sorry, the formula you have dialed is not known. Please press these keys and try again: =AND(L4<=TODAY(),ISBLANK(N4))