Forum Discussion
Excell Conditional Formatting
I want to enter a conditional formatting so when the "next due" date is overdue the "condition" column value changes to NT, can anyone help me out with a dummies guide?
1 Reply
Nllewellyn88 Conditional formatting can't change a cell's value. You'd need a formula for that. What constitutes being overdue? If it's before today's date, then you could use something like this:
=IF(E2<TODAY(),"NT","")
HTH
