 You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
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)