Conditional formatting based on day of month

[SinGin]

If I have the days of the month listed in row 3 (ie 1-31 for the month of July), what code could I use to have the cell that contains the number that corresponds to the present day of the month change color. For example: if it’s 21 July 2010, I would want the cell that has the number 21 in it to turn red. Any help would be greatly appreciated.

I know how to have conditional formatting change the cell if the entire date is in the cell, but I don’t want the cells to contain the entire date. They’d be too wide. I want it to look more like a calendar.

[NBVC]

If the entire date is in the cell, but it is just formatted to show day with d or dd custom format, then you can still use the date.

i.e. Cell Value is >> equal to >> =Today()

[daddylonglegs]

If you just have numbers in the cells you can use

=A3=DAY(TODAY())

[NBVC]

If you just have numbers in the cells you can use

=A3=DAY(TODAY())

Only thing is is that if the OP has a whole calendar (more than just July), then that would highlight all the 21st dates of the calendar...

[SinGin]

Thanks all; works great!!