overdue item tracking

i have an agreement with a service station that items i send to them will be returned fixed with in 3 working days. I wanted to create something easy to following even with just a glance.

I want to be able to look back and check how many items had been returned overdue.

[TABLE="border: 0, cellpadding: 0, cellspacing: 0"]

[tr]

[TD="class: xl65, width: 77"] [/TD]
[TD="class: xl65, width: 102"] [/TD]
[TD="class: xl65, width: 101"][ATTACH=JSON]{"data-align":"none","data-size":"full","title":"excel.jpg","data-attachmentid":1201031}[/ATTACH][/TD]

[/tr]

[tr]

[TD="class: xl66"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl67"] [/TD]

[/tr]

[tr]

[TD="class: xl64"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl67"] [/TD]

[/tr]

[tr]

[TD="class: xl64"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl67"] [/TD]

[/tr]

[tr]

[TD="class: xl64"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl67"] [/TD]

[/tr]

[tr]

[TD="class: xl64"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl67"] [/TD]

[/tr]

[tr]

[TD="class: xl64"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl67"] [/TD]

[/tr]

[tr]

[TD="class: xl64"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl67"] [/TD]

[/tr]

[/TABLE]

i started by using =IF(B2="","",IF((NOW()-B2)>3,"Yes","")) (for column C) and formated the cells to turn red and enter "YES (for overdue) and green"and blank (when not over due)

I realised that by using NOW() as each day passes they will slowly turn red "YES"

what i need is that :
if more than 3 days have passed since DATE SENT to inform column OVERDUE with a "YES" and turn red.
When 3 days havent passed to leave the column OVERDUE blank and green
BUT if a DATE RECIEVED has been entered to calculate if it had been more than 3 days(between date sent and date recieved) and mark the OVERDUE column accordingly again.(red and yes or green and blank).

Thanks in advance for any help.

Thanks for helping,

I took a look at your sheet and saw the formula in cell C2 is different for the formulas in C3:C5 whats the difference between them?

Ive tried both, currently the formula in C2 seems to work, ill put some data to test it some.
The formula in C3:C5 to always result in a formated RED Yes.

yes that works great.

Thank you very much for your help.