Hi,

I don't really understand what you are trying to do but if you want a
selection of cells to check A1 & A2 then do this. Select those cells then
apply this slightly modified conditional format

=AND($A$1="Off",ISNUMBER($A$2),$A$2<TIME(6,0,0))

Mike

" wrote:

Thanks Mike,
Now how do I apply that formula to a whole rang of cells within that
column.
Sorry if these are simple questions, but I didn't seem to get any
sense from the built in help!

Neill