Non dealing customer detail with color code

[avk]

Hellow friends
I have two excel files. One is temp.xls my data bank in this file in databank sheet with details of invoice no, invoice date, customer code, customer name, machine no, partno, quantity, rate & amount.

In second file name temp_avk.xls in this file we have customer machine details like customer code, customer name, machine number, date of machine install, address, contact persons, telephone number, city, district etc.

Now i m trying to show customer last invoice number, date with color code in temp_avk.xls file in result sheet of column : g. Explaination as per below :-

Show customer last invoice no & date in col: g. If both not possible in one cell then separately show in col : g & h.

Invoice details as per other excel file name: temp.xls in sheet1. If today is 12th feb 2010 (take system date automatically) Also those customer last invoice number date is more than 4 months (calculate from today & today date take from system date) i.e. if last invoice prepaired in the month of 31 may 2009 it means more than 4 month those cell show in red color. Even if thier is no dealing from long time/period they also show as blank cell or with message "alram no deal" with red color. And if customer invoicing within 2 or 3 month (which is calculate from today i.e. 12th feb 2010) those cell show invoice no & date in green color.
Invoice no & date show in one column if possible other wise invoice date show seprately in other column i.e. in column : H.

We have attach both files for your ready ref. I dont want through access or vba because i m not familier with vba or access.

[avk]

bump no reply.

[avk]

Hellow friends,

bump no reply.

[avk]

bump no reply.