Formatting cells depending on date/customer

[turborat]

Hi,

In the table below I have 3 columns, "Date of RMA request", "Mt-MO Country" & "Term Status".

What I need to do is to be able to show the text "Invoice" in column 3 when the date in column 1 is =>30 days.

Where I am having issues is that I also need to show the same text when it is also => 60 days as we have differnt comapny's with differnt terms (30 or 60 days).

So I need to be able to show the text "Invoice" when , depending on a certain company name) when their terms exceed either 30 or 60 days depending on account terms.

I hope this makes some kind of sense!


<TABLE style="WIDTH: 308px" border=0 cellSpacing=0 cellPadding=0>
<COLGROUP><COL width=81></COL><COL width=100></COL><COL width=127></COL></COLGROUP>
<TBODY>
<TR height=51>
<TD class=xl64 height=51 width=81>Date of RMA Request</TD>
<TD class=xl64 width=100>MT MO (Country)</TD>
<TD class=xl64 width=127>Terms Status</TD>

</TR>
<TR height=30>
<TD class=xl70 height=30 width=81>04/01/2011</TD>
<TD class=xl69 width=100>Mert Teknic</TD>
<TD class=xl69 width=127> </TD>

</TR>
<TR height=19>
<TD class=xl73 height=19 width=81>04/01/2010</TD>
<TD class=xl72 width=100>MT-PL</TD>
<TD class=xl72 width=127> </TD>

</TR>
<TR height=20>
<TD class=xl67 height=20 width=81>04/01/2011</TD>
<TD class=xl75 width=100>MT-S</TD>
<TD class=xl75 width=127> </TD>

</TR>
<TR height=35>
<TD class=xl73 height=35 width=81>05/01/2011</TD>
<TD class=xl72 width=100>MT-K</TD>
<TD class=xl72 width=127> </TD>

</TR>
<TR height=20>
<TD class=xl70 height=20 width=81>06/01/2011</TD>
<TD class=xl69 width=100>MT-UK</TD>
<TD class=xl69 width=127> </TD>

</TR>
<TR height=103>
<TD class=xl73 height=103 width=81>06/01/2011</TD>
<TD class=xl72 width=100>MT-D</TD>
<TD class=xl72 width=127> </TD>

</TR>
<TR height=86>
<TD class=xl73 height=86 width=81>10/01/2011</TD>
<TD class=xl72 width=100>SL-US</TD>
<TD class=xl72 width=127> </TD>

</TR>

</TBODY>

</TABLE>


Thanks!

 

[SteveO59L]

Have a look at conditional formatting

 

[turborat]

Thanks for getting back to me.

I need this to happen automatticaly with out any additional input so we can see straight away if a certain account/customer has exceeded the specific terms (30 or 60 days).

 

[SteveO59L]

Thats what conditional formatting does