Conditional formatting with time

[dunnobe]

Dear all,

I'm trying to apply a conditional formatting to a column and I would like to highlight all time values >= 9:30:00

My current format does this, but unfortunately it also formats the blank ("") cells.

I guess I need some IF condition or NOT to resolve this, but I'm too inexperienced to find the solution (and Google doesn't help ).

Solution

IF blank ("") THEN no formatting
IF < 9:30:00 THEN no formatting
IF >= 9:30:00 THEN formatting

Could any1 help?

Best regards,

dunnobe