Forum Discussion
Time Conditional Formatting Help
Hi Excel folks, I'm stuck on how to get a conditional formatting for time to work. I've tried MANY different iterations and it's not working. One of them seemed to highlight part of what I wanted...
That's like
In formula it shall be reference on first cell in the range if that's not M1.
In future please submit small sample file instead of / in addition to copy/pasted as text range.
I attached a sample of my data, I am using Office 2016.
When I tried it, it wouldn't work the way it did for you. Does it matter that I factored in headers? I made it M2 instead of M1. Not sure if my picture that I tried to upload worked, I can't see it again.