![]() |
sorting by dates -- parameters?
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 |
All times are GMT +1. The time now is 08:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com