Ok this is what i would like to do, if any kind person could help:

I have i sheet with a description and a date which will be added t
when someone close the sheet i want the infor to be sorted by dat
order column b

Also i want the sheet to check the date in column b with the compute
date. if the date has past then that row is highlighted red.

i.e. the date the request was maded 26/05/04 Wed the sheet is open
today 01/06/04 then that row would be cloured red.

Thanks in advance

--
Message posted from http://www.ExcelForum.com