Showing the column of current day
 

Hello.
I have a worksheet that is like a calendar, with a column for each
day. I want to keep track of past days and also to show future days,
exactly like a calendar. I'd like Excel to show the current day as the
first column (it would be useful instead of scrolling the worksheet to
the column corresponding to the current day). How can I do that?
Thanks for help.

Sepiax

How about using conditional formatting to highlight the today column?

select all date columns (suggest that you only select a subset of rows, not
all)
I am assuming the start row is 2, start column is A, the day of the date is
in row 1, and you haven't selected row 1
goto FormatConditional Formatting
change condition to Formula Is
add a formula of =A$1=DAY(TODAY())
click the Format button
select the Pattern tab
choose a colour
OK out


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Sepiax" wrote in message
om...
Hello.
I have a worksheet that is like a calendar, with a column for each
day. I want to keep track of past days and also to show future days,
exactly like a calendar. I'd like Excel to show the current day as the
first column (it would be useful instead of scrolling the worksheet to
the column corresponding to the current day). How can I do that?
Thanks for help.

Sepiax