I have a column that I would like to change color once an certain criteria
has been met.

Example:
Column A Cells --A1:A23 has various dates 01/02/09-08/10/09.

A:125 has date of 12/01/09.

Once the date of 12/01/09 has been entered in any cell within the range of
A1:A124 I want the entire column to change color.