I'm trying to do a conditional formatting that will highlight any times past 5:00 PM.. I tried this but it didn’t work: =IF(a:a<"5:01:00 PM")

See attached. can someone help please?

Thank you,
Trish

Book1.xlsx