Conditional formatting a cell colour between specific times

Hi there, Im trying to create a spreadsheet that is filled out at work at the end of each 12 hour shift. Its basicly just an ongoing table of Brewery tanks and contents etc. I have attached a very basic example of the spreadsheet (the actual spreadsheet is huge, with much more info,, but its at work and im now at home trying to get this worked out).

All I want is for a cell some where on the current shifts spread sheet to colour green to indicat that this is the sheet the operator should be filling out, so that its a little harder to accidentaly fill out a sheet for the wrong day. I have purposly coloured a cell at the top of the screan as an example of how i would like it to look (although it doesnt have to be the date cell)

Im hopeing that this can be done and that at 7am tomorrow morning the cell for the next days day sift will automaticaly go green, indicating that we are now to start using the sheet for the next day.

Can this be done?

I thought I had it when I set the cell to "format only cells with dates occouring today", but as the shift run from 7am-7pm and 7pm-7am etc this does not work.


Many thanks in advance!

David