Hi Im on excel 2010
I have Cell A2 with TODAY() giving todays date ie 26/10/2011
In Cell H5 down to H500 i have dates

I want to use conditioning format so that all cells with dates less than todays date fill in Red

Please help