Highlight Time
 

I have created a spreadsheet that requires an employee to enter data at a
specific time. The spreadsheet is Quarterly for every half hour. I have
copied the information to all of the cells to remain the same until the data
is changed. Is there a way I can hightlight cell for the current time frame.
Thank you in advance for you assistance.

Assuming that your quarter hour time slots are in A2:A97, you could use
conditional formatting with a formula of
=AND(A2<=MOD(NOW(),1),MOD(NOW(),1)<A3)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"B. Richey" <B. wrote in message
...
I have created a spreadsheet that requires an employee to enter data at a
specific time. The spreadsheet is Quarterly for every half hour. I have
copied the information to all of the cells to remain the same until the
data
is changed. Is there a way I can hightlight cell for the current time
frame.
Thank you in advance for you assistance.