Pasty,

You can create as many conditions as you like:

If myCell.Value < "" And _
myCell.Value <= Now + 30 And _
myCell.Value = Now And _
myCell(1, 2).Value < "Notified" Then

HTH,
Bernie
MS Excel MVP


"Pasty" wrote in message
...
Hi there,

Its because the due date on some of the cells is less than the the date so
it is seeing it as an error. So I need to figure out how to get it to say if
the due date has passed then ignore and go through the rest and this is where
I am struggling.

Regards

Matt

"Bernie Deitrick" wrote:

Sorry. With the address in quotes, since it needs to be a string...

.Recipients.Add ")


HTH,
Bernie
MS Excel MVP