You could do it without a macro using conditional formatting

select whole table with A1 active cell, assuming top left cell of table
is A1 (adjust accordingly if not) use

Format Conditional Formatting formula is

=A$1=TODAY()

select desired formatting


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=512886