One way to highlight using Conditional Formatting ..

Assuming your dates are running in A1 down

Select col A (A1 active)
Click Format Conditional Formatting
Under Condition 1, make the settings as:
Formula is:
=AND(A1=--"12-Jan-2007",A1<=--"5-May-2007")
Click Format Patterns tab Blue? OK
Click OK at the main dialog

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Chi" wrote:
Hi,

I have a column stored a list of birthday dates. I would like to know who
have birthdays between two dates.


Ex: Between 01/12/2007 to 05/22/2007. I wanted to see all dates that are
between 01/12/07 to 05/22/07.

Thanks
chi

Thanks
Chi Huynh