If you input the dates in a worksheet cell, you could use Conditional
Formatting to highlight matches.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"neowok " wrote in message
...
i have some tables, each table has 9 columns and columns 6 and 7 are
'start date' and 'finish date'.

What i want to do is let someone type in a date (in a text box) and
then have it show all the rows where the date they typed in is between
the start and finish date for that row.

not sure if its possible to do this with autofilter but if it is then
that would probably be the best way.


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