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)
Thanks for your help, but it doesn't work for some reason. I'm doing something wrong, but I'm not sure what. Please, here is step by step of my work, maybe you can see something?
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 a Star 🙂 Is working now
Thanks