How to use conditional formatting to highlight cells with time between 8:30am-17:30pm
Hello!
Each week I need to format a call logs report where column A is the date + time of the call.
I have been trying to figure out the conditional formatting formula to highlight rows between 8:30am – 17:30pm in red, but I can only seem to make it work for whole hours (8am-5pm)
I am currently using the following formula:
=OR(HOUR(A1)=8, HOUR(A1)=9, HOUR(A1)=10, HOUR(A1)=11, HOUR(A1)=12, HOUR(A1)=13, HOUR(A1)=14, HOUR(A1)=15, HOUR(A1)=16, HOUR(A1)=17)
Is there a way to get this to work for 8:30-17:30? I have tried making it HOUR(A1)=8,3,0 with no luck.
Thank you!
Hello!Each week I need to format a call logs report where column A is the date + time of the call.I have been trying to figure out the conditional formatting formula to highlight rows between 8:30am – 17:30pm in red, but I can only seem to make it work for whole hours (8am-5pm) I am currently using the following formula:=OR(HOUR(A1)=8, HOUR(A1)=9, HOUR(A1)=10, HOUR(A1)=11, HOUR(A1)=12, HOUR(A1)=13, HOUR(A1)=14, HOUR(A1)=15, HOUR(A1)=16, HOUR(A1)=17) Is there a way to get this to work for 8:30-17:30? I have tried making it HOUR(A1)=8,3,0 with no luck. Thank you! Read More
