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?