Column conditional formatting
 

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.

Column conditional formatting
 

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

Column conditional formatting
 

That works, Bryan, thank you so much.
But if I modify the formula for TODAY()-1 shouldn't I get the formatting in
the column from the prior day? When I do it that way, it formats the column
from 3 days prior. E.g., if the current day is Monday and the above formula
is applied it formats the previous Friday. I must be missing something in the
logic of the formula. I am assuming MS has their code right to begin with.
Running Excel '03 on XP sp2.

"Bryan Hessey" wrote:


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