Formula/format base don another conditional format

I hope my description is okay.

Here goes ........ I have an excel table (see below) which as a column calculated on the column before. I need to have a nother column return words based on this calculation.

A = reference
B = a future date
C = days from today based on the (calculation =DAYS360(A1,B2) etc
-- this has a conditional format attached:
-- green if C is >180
-- orange if C is between 0 & 179
-- red is less than 0
D = i need this column to state
-- "in" if C is >180
-- "due" if C is between 0 & 179
-- "overdue" if C is less than 0


A B C D
1 =today()
2 Hit1 30/04/14 679
3 Hit2 05/03/14 624
4 Hit3 01/04/12 -70
5 Hit4 06/06/13 355
6 Hit5 31/07/12 50

Many thanks for reading the above and for you help - Adam

Hope this works

Column D has been ;left blank as this is the column i need to complete with "in", "due" or "overdue"

This is brilliant and works fab

Is there a way to include other parts for example if a cell C6 has the word new in it can this be included in the formula?

Brilliant - many thanks