Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 7th 07, 11:02 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2007
Posts: 3
Default Excel to recalculate a worksheet based on a time interval

I want to be able to use Conditional formatting to highlight a section of a
worksheet based on the current time. I know that I can get the current time
and I know how to Conditional format. My problem is how do I get the
worksheet to update the current time on a regular basis without me forcing a
recalculate manualy or reopening the worksheet

  #2   Report Post  
Old March 7th 07, 11:06 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 11,058
Default Excel to recalculate a worksheet based on a time interval

Use an OnTime event procedure.
--
Gary''s Student
gsnu200709


"HeireneM" wrote:

I want to be able to use Conditional formatting to highlight a section of a
worksheet based on the current time. I know that I can get the current time
and I know how to Conditional format. My problem is how do I get the
worksheet to update the current time on a regular basis without me forcing a
recalculate manualy or reopening the worksheet

  #3   Report Post  
Old March 7th 07, 12:10 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2007
Posts: 3
Default Excel to recalculate a worksheet based on a time interval

How do I do this?. I typed it into the help page and got nothing

"Gary''s Student" wrote:

Use an OnTime event procedure.
--
Gary''s Student
gsnu200709


"HeireneM" wrote:

I want to be able to use Conditional formatting to highlight a section of a
worksheet based on the current time. I know that I can get the current time
and I know how to Conditional format. My problem is how do I get the
worksheet to update the current time on a regular basis without me forcing a
recalculate manualy or reopening the worksheet

  #4   Report Post  
Old March 7th 07, 01:37 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 11,058
Default Excel to recalculate a worksheet based on a time interval

see:


http://www.cpearson.com/excel/ontime.htm



--
Gary''s Student
gsnu200709


"HeireneM" wrote:

How do I do this?. I typed it into the help page and got nothing

"Gary''s Student" wrote:

Use an OnTime event procedure.
--
Gary''s Student
gsnu200709


"HeireneM" wrote:

I want to be able to use Conditional formatting to highlight a section of a
worksheet based on the current time. I know that I can get the current time
and I know how to Conditional format. My problem is how do I get the
worksheet to update the current time on a regular basis without me forcing a
recalculate manualy or reopening the worksheet

  #5   Report Post  
Old March 7th 07, 01:51 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2007
Posts: 3
Default Excel to recalculate a worksheet based on a time interval

Thanks, looks a little complicated but I will work through it.

"Gary''s Student" wrote:

see:


http://www.cpearson.com/excel/ontime.htm



--
Gary''s Student
gsnu200709


"HeireneM" wrote:

How do I do this?. I typed it into the help page and got nothing

"Gary''s Student" wrote:

Use an OnTime event procedure.
--
Gary''s Student
gsnu200709


"HeireneM" wrote:

I want to be able to use Conditional formatting to highlight a section of a
worksheet based on the current time. I know that I can get the current time
and I know how to Conditional format. My problem is how do I get the
worksheet to update the current time on a regular basis without me forcing a
recalculate manualy or reopening the worksheet



  #6   Report Post  
Old March 7th 07, 03:12 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 11,058
Default Excel to recalculate a worksheet based on a time interval

If you run into problems, just update this post
--
Gary's Student
gsnu200709


"HeireneM" wrote:

Thanks, looks a little complicated but I will work through it.

"Gary''s Student" wrote:

see:


http://www.cpearson.com/excel/ontime.htm



--
Gary''s Student
gsnu200709


"HeireneM" wrote:

How do I do this?. I typed it into the help page and got nothing

"Gary''s Student" wrote:

Use an OnTime event procedure.
--
Gary''s Student
gsnu200709


"HeireneM" wrote:

I want to be able to use Conditional formatting to highlight a section of a
worksheet based on the current time. I know that I can get the current time
and I know how to Conditional format. My problem is how do I get the
worksheet to update the current time on a regular basis without me forcing a
recalculate manualy or reopening the worksheet



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 X-ax reflect correc time interval when don't have all points Narges Charts and Charting in Excel 1 April 12th 06 04:00 PM
Calculating time interval (some across midnight) [email protected] Excel Worksheet Functions 3 January 17th 06 05:50 PM
Calculations with date time interval Todd F. Excel Worksheet Functions 6 September 22nd 05 07:43 PM
Counting datapoints/records in time interval [email protected] Charts and Charting in Excel 1 April 15th 05 05:46 AM
time interval calculations in excel Krishna Excel Discussion (Misc queries) 6 April 8th 05 02:57 PM


All times are GMT +1. The time now is 12:50 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017