yogi_Conditionally Format A3:G If Cells in column E or F Have Time Value > 18:00

Google Spreadsheet   Post  #2573

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Jan-09-2019

question by: TJ G:
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/A9DIl4VtPO0;context-place=forum/docs
Conditional formatting with MM:SS value
Hi,

I'm trying to figure out a custom conditional formatting formula. My goal is: I want to highlight an entire row if I enter into a cell a length of time greater than 18 minutes, or 18:00 (i.e. 18:34, 18:45, etc). 

If I were wanting to highlight a single cell, that is easy enough to do in conditional formatting by choosing a cell for my "apply range", selecting the "greater than" option, and entering 18:00 as a value.

But, If I select a row for my "apply range", then choose "custom formula is" and enter something like =$E3>18:00 where I'd expect a value greater than 18:00 being entered into E3 would highlight the entire row, except it claims the formula is invalid. I'm assuming the colon in the time value is screwing things up, but I do not know of any other way to indicate the length of time in the formula.

Any help?