Conditional Formatting Based on Today Function

[Madball]

Hello,

I am posting today to find out if there is anyone here that may know how to create conditional formatting based on the TODAY() function. basically I want along ROW1 of my excel spreadsheet a list of dates, so for example A1 to A10 will be shown like this 01/01/2012, 02/01/2012, 03/01/2012 etc... Then on ROW2 within the same range it will have the formula =TEXT(cell above,"DDD").

Now using conditional formatting when the date in ROW1 equals present day it will change the background colour of the cell to a different colour and in addition also change the colour of the cell below to the same colour. I've been trying this for a bit now and I can't get my head around it.

I have also created an excel workbook that I have attached to this post.