I have a row of dates that I wish to have flled once a condition has been
met. ( i have excel 2003)

Example
A1:A25 have various dates 01/02/09 thru 06/05/09.(dates will change
according to deadlines)

A124 has a date of 10/25/09.
When the A1:A25 fields dates change to say 10/25/09, I want the entire
column, A1:A124 to change a particular color.