Highlight Time

[B. Richey]

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.

 

[Bob Phillips]

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)