Excel Formula Help

Hi Guys,

not sure whether anyone can help with this but i will try anyway, i have created a spreadsheet as per below:

<table border="0" cellpadding="0" cellspacing="0" width="479">

<colgroup><col width="99" style="width:74pt"><col width="109" style="width:82pt"><col width="132" style="width:99pt"><col width="75" style="width:56pt"><col width="64" style="width:48pt"></colgroup>

<tbody>

<tr height="20" style="height:15.0pt">

<td height="20" width="99" style="height:15.0pt; width:74pt">Ticket Number</td>

<td width="109" style="border-width:82pt">Work awaiting</td>

<td width="132" style="border-width:99pt">Original Due Date</td>

<td width="75" style="border-width:56pt">Status</td>

<td width="64" style="border-width:48pt"> </td>

</tr>

<tr height="20" style="height:15.0pt">

<td align="right" height="20" style="height:15.0pt">2758</td>

<td style="">  HLE</td>

<td align="right" style="">07/06/2012</td>

<td align="right" style="">8.00</td>

<td style="">Days</td>

</tr>

<tr height="20" style="height:15.0pt">

<td align="right" height="20" style="height:15.0pt">2498</td>

<td style="">  HLE</td>

<td align="right" style="">31/05/2012</td>

<td align="right" style="">1.00</td>

<td style="">Days</td>

</tr>

<tr height="20" style="height:15.0pt">

<td align="right" height="20" style="height:15.0pt"> 2845 </td>

<td style="">  HLE</td>

<td align="right" style="">28/05/2012</td>

<td align="right" style="">-2.00</td>

<td style="">Days</td>

</tr>

</tbody>

</table>

the columns are A,B,C,D. The Status coloumn needs to be able to calculate the difference between todays date and the due date, the Status coloumn needs to show the amount of days remaining and a minus if its overdue but also if the Status is 4 days or more

away the cell is filled green, if it is 1-3 days away the cell needs to fill Amber and if it is 0 or a minus amount of days it needs to fill the cell Red, but you still need to see the information.

any ideas guys?

Thanks Brad

View this thread