software

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 lt;gt; TODAY, it remains unformatted.


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:
gt; My table has a unique date in each column from left to right. What
gt; formula
gt; would automatically format/fill the entire column (e.g. A1:A50) if the
gt; cell
gt; with the date = TODAY and then replicate itself for each column
gt; therafter?
gt; Obviously, if the date lt;gt; TODAY, it remains unformatted.--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
View this thread: www.excelforum.com/showthread...hreadid=531109That 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.

quot;Bryan Hesseyquot; wrote:

gt;
gt; Select the whole worksheet (click the Data Select cell to the left of
gt; column header A and above the row number 1), then select
gt;
gt; Format,
gt; Conditional Format,
gt; Formula is
gt; =(A$1=TODAY())
gt; set the Patern colour required,
gt; OK
gt;
gt; Row 1 is assumed to have the date for each column.
gt;
gt; --
gt;
gt;
gt; Rhys'''' Pieces Wrote:
gt; gt; My table has a unique date in each column from left to right. What
gt; gt; formula
gt; gt; would automatically format/fill the entire column (e.g. A1:A50) if the
gt; gt; cell
gt; gt; with the date = TODAY and then replicate itself for each column
gt; gt; therafter?
gt; gt; Obviously, if the date lt;gt; TODAY, it remains unformatted.
gt;
gt;
gt; --
gt; Bryan Hessey
gt; ------------------------------------------------------------------------
gt; Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
gt; View this thread: www.excelforum.com/showthread...hreadid=531109
gt;
gt;