Try this conditional format formula in A1

=AND(A1="Off",ISNUMBER(A2),A2<TIME(6,0,0))

Mike

" wrote:

I have a column of cells which are formatted as either General or
hh:mm.
What I want is - if A1 = Off & A2 is less than 06:00 then A1 is
highlighted in red text.
Haven't found anything that works yet.
Can anyone help?
Thanks