Hi

I am looking to highlight a cell that falls between two hours.
I.E. I have a spreadsheet with hours
14:00 - 15:00
15:00 - 16:00
16:00 - 17:00
I want the spreadsheet to check the current time ( NOW() ? ) and then highlight the cell that falls between that time.
So if it is 16:34 then the cell between 16:00 - 17:00 should be highlighted.

thanks in advance