As Bob says, you can select the whole range first and then apply Mike's
original formula adjusted for your cell refs, so......

If your range is C1068:C2000 select that whole range and use

=AND(C1068="Off",ISNUMBER(C1069),C1069<TIME(6,0,0) )

" wrote:

The columns will get very long and will contain either a time or
"Off".
If the cell below "Off" is after 06:00 there's no problem, If it's
before 06:00 then "Off" needs highlighting.
The first formula you gave works great (I've changed the cell
references to C1068 & C1069 to fit in with my table), but when I
select all the cells I want it to apply to, then either "edit rule" or
"new rule" & paste the formula in, it doesn't seem to work.
Thanks again