ExcelBanter - real date for column

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - real date for column (https://www.excelbanter.com/new-users-excel/50113-real-date-column.html)

Jay

real date for column

I want to program my worksheet as calender. I need the current date column to
show highlighted and then move across sheet day to day when the date actually
changes (real time).
--
Jay

Bob Phillips

Use conditional formatting and test for TODAY().

--
HTH

Bob Phillips

"Jay" wrote in message
...
I want to program my worksheet as calender. I need the current date column
to
show highlighted and then move across sheet day to day when the date
actually
changes (real time).
--
Jay

Jay

real date for column

Thanks worked like a champ.
--
Jay

"Bob Phillips" wrote:

Use conditional formatting and test for TODAY().

--
HTH

Bob Phillips

"Jay" wrote in message
...
I want to program my worksheet as calender. I need the current date column
to
show highlighted and then move across sheet day to day when the date
actually
changes (real time).
--
Jay

All times are GMT +1. The time now is 01:46 AM.