Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
entering numbers to display a time format | Excel Discussion (Misc queries) | |||
Help - Information with time and date | Excel Discussion (Misc queries) | |||
time sheet | Excel Worksheet Functions | |||
Round Time | Excel Worksheet Functions | |||
time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions |