Macro/conditional formatting
 

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.

Mac,

You can use conditional formatting. Format - Contitional formatting. It's
not necessary to have them sorted for that.

As for automating it, if you're truly importing (not opening), you can have
the import specs, conditional formatting, all set up in a workbook. Then
you just take a copy of the file, do the import, and you're ready to go.
Read up on importing vs. opening at www.smokeylake.com/excel. "Text files
and Excel."
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"BigMac" wrote in message
...
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.