This is the formula I used

=IF(AND(NOW()B8,C8=""),"Over Due","")

I assume if the payment is made late You don't want want anything displayed.
You just asked if it is overdue.

The formula below displays Overdue if the paymentt wasn't made and Late if
the payment was made Late

=IF(AND(NOW()B8,C8=""),"Overdue",IF(C8B8,"Late", ""))

"BrettPotts" wrote:

Hi,

I have a 5 colum spreadsheet i need some advice with.

Colum A - Is the date account sent
Colum B - Is the date account due by
Colum c - Is the date account payment is recieved
Colum d - Is the difference between A & C

In Colum E i need a rule to highligh a cell once it has past its overdue
date which is C .. I am more than happy to email the file over for you to
have a play as i am really stumpted! My email addy is

Hope you can help!