I use Excel at my job as a dispatch board that lists all of our tasks for the
day and what time we need to start it and complete it by. Is there a way to
format a column so that when we're reaching the time, it will change the
background color?
We use military time...
I would like it to change color 15 minutes prior to the time and again when
it is that time. Is this possible?

Look at the OnTime method in VBA help files.

"Melissa" wrote:

I use Excel at my job as a dispatch board that lists all of our tasks for the
day and what time we need to start it and complete it by. Is there a way to
format a column so that when we're reaching the time, it will change the
background color?
We use military time...
I would like it to change color 15 minutes prior to the time and again when
it is that time. Is this possible?

Select the range of cells of which you want to change the colors. Then
go to the Format menu and choose Conditional Formatting. In that
dialog, change "Cell Value Is" to "Formula Is" and enter the following
in the formula box:

=IF(A1<(NOW()-TODAY()),(NOW()-TODAY()-A1)<TIME(0,15,0))

Change all the references to A1 to the first cell in the range of
cells to be colored. Then, click the Format button to select the
format of the cells. This custom format will be applied if the current
time of day is less than 15 minutes prior to the time in A1. It will
not apply the format if the current time of day is later than the time
in A1.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)



On Wed, 10 Dec 2008 13:21:01 -0800, Melissa
wrote:

I use Excel at my job as a dispatch board that lists all of our tasks for the
day and what time we need to start it and complete it by. Is there a way to
format a column so that when we're reaching the time, it will change the
background color?
We use military time...
I would like it to change color 15 minutes prior to the time and again when
it is that time. Is this possible?