How do i do this on excel?

1 column of dates when items are due.

2nd column showing dates when items received.

I want second column cells to turn red if the due date in column 1 passes and no date has been entered in 2nd column, based on todays date.

If date is entered then formatting reverts to normal.

Tried conditional formatting & IF statements, but maybe i need a combo of the 2? cant get my head around it.

Any ideas?

In B1 (and able to be <copy, paste special, format> down) apply the conditional format:

Formula is “=AND(A1<TODAY(), B1=””)”

Edit: ignore me.

based on todays date

just a bronze star for you njee 😉

EDIT: bronze star withdrawn for stealth edits too!

that forumla gives a circular reference?

and returns the value “00 january 1900”

Assume today’s date is in A1 and your due date column is b and c is your next column

Conditional formatting in column c is =and(C1=0,$A$1>B1) then format applies

Oh and “you wait all year for an excel conditonal formatting thread and 2 come along at once”

Strange that I didnt see the other thread before posting this one.

organic – it’s not a formula you type on the cell, its a formula you type in the “Formula is” box in conditional formatting.

Assume today’s date is in A1

bleuuughghh.

That’s why god invented =TODAY()

But if you want to see what will be overdue in a week you can just change the date in cell a1 and it will show you – future proofing don’t you know

But if you want to see what will be overdue in a week

add a single “days till due” input cell.

then
“=AND(A1<(TODAY()+$Z$1), B1=””)”

Each to their own, I would prefer to see the date (especially on a print off from the day before)