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))"
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))"