I have a problem copying Conditional Formatting in Excel 2007

I am using the formula (shown below) in cell I1 to format that cell with
conditional formatting. When I copy this formula to cells I2 through to
I10, I wish to have the reference change from A1 to A2, A3 etc. to match the
cells I2, I3 etc

=A1Today()

However, I end up with the same cell reference A1 and the 'applies to'
changes from I1 to I2:I10.

I have tried using copy & paste, format painter all give the same result.

I have read previous posts stating to ensure that A1 is not an absolute
reference which I believe I have done. Also I read a post somewhere that
this might be a bug in Excel 2007, but I can't find it again.

Any help would be appreciated, i have several hundred cells that I wish to
format.

Thanks