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