Forum Discussion
Solved
Conditional formatting based on time (00:00:00)
Please can you help me find a solution to the following question? I keep a record of what time the user updates data. The allowed time is one hour before and one hour after the allotted time. Let's ...
Perhaps column D contains date + time values instead of just time values. Does this formula for the "green" rule work?
=OR(HOUR(D43)=8,HOUR(D43)=9)
Thank you, Hans
You're welcome!