Forum Discussion
Steve_Barone
Sep 18, 2020Copper Contributor
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...
HansVogelaar
Sep 18, 2020MVP
It appears to work - see the screenshot and attached workbook.
If you can't get it to work, could you attach a copy of your workbook without sensitive/proprietary information?
Steve_Barone
Sep 18, 2020Copper Contributor
Thanks, I attached a bit of the data in my other reply, with all sensitivity removed.
- HansVogelaarSep 18, 2020MVP
The formula in C2 should be =B2-A2, not =TEXT(...).
And your conditional formatting formula should not refer to M2 in this sample workbook but to C2, of course.
But it's easier to use a rule of the type "Format only cells that contain".