consider using conditional formating. see:


http://www.contextures.com/xlCondFormat01.html



--
Gary's Student
gsnu200703


"Philip Drury" wrote:

I have a spreadsheet where we are capturing customer contact. The first
column contains the date that the call came in, I want to format the table to
make the row green if the date in column 1 is within 5 days from todays date,
to turn amber if it goes over 5 days and red if it goes over 7 days. The
last column will contain the date that the query was completed, when a date
is input into this field I want the row to 'grey' out. Can anyone help????