Select the whole worksheet (click the Data Select cell to the left of
column header A and above the row number 1), then select

Format,
Conditional Format,
Formula is
=(A$1=TODAY())
set the Patern colour required,
OK

Row 1 is assumed to have the date for each column.

--


Rhys'''' Pieces Wrote:
My table has a unique date in each column from left to right. What
formula
would automatically format/fill the entire column (e.g. A1:A50) if the
cell
with the date = TODAY and then replicate itself for each column
therafter?
Obviously, if the date < TODAY, it remains unformatted.


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=531109