Column conditional formatting

  • Thread starter Rhys'''' Pieces
  • Start date
R

Rhys'''' Pieces

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.
 
B

Bryan Hessey

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.
 
R

Rhys'''' Pieces

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.
 
Top