Forum Discussion
Expiry date help.
Hi, i am looking for a formula to turn a cell different colours as a test expiry date approaches. I have column D with the date the test was taken. I then have column E with the formula =IF(D3=""...
Yes, indeed.
Hi Hans, the formula seems to work however, i want to show it as overdue as well. Would this just be a case of using conditonal formatting to change it red with the below formula?
=AND($E3<>"", $E3=EDATE(TODAY())
Ive been playing and cant seem to get it to work.
Thank you in advance.