Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Jay
 
Posts: n/a
Default 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
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

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



  #3   Report Post  
Jay
 
Posts: n/a
Default 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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I create a schedule from a list of dates ? Gavin Morris Charts and Charting in Excel 2 October 28th 10 04:08 PM
NETWORKDAYS - Multiple Date Selection Annabelle Excel Discussion (Misc queries) 3 October 4th 05 07:04 PM
How do I calculate if a date is in a certain time frame? Pe66les Excel Worksheet Functions 19 August 27th 05 11:07 PM
search for latest date Sue Excel Worksheet Functions 2 August 2nd 05 11:09 PM
how to include real time & date on a worksheet nde Excel Discussion (Misc queries) 1 March 23rd 05 07:43 PM


All times are GMT +1. The time now is 09:20 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"