Every day I receive a tab delimited file that I open in
Excel. The file contains a date field and the first record
is always in row 6, with the date in cell E6. Each tab
delimited file I receive contains a different number of
records. When I import the file, I always make sure that
the Date field is imported as a date field rather than a
General field.

After I import the tab delimited file, I sort E6:E???
(number of records varies) in ascending order. Then I
manually identify records that fall into the less than 30
day from today range and color those cells green, then I
identify those records in the 31 - 60 range and color
those yellow, and finally, those records greater than 61
days I color red.

I then save the file as an .xls file.

It seems to me that I should be able to automate the cell
coloring process each time I import a file, but don't know
how.

Your help is greatly appreciated.