Cell color change base off of date and time

Hello,

So I have read through a few different threads here but cannot seem to find one that fits the problem that I have exactly.

The goal is to get cells A-D (for the row with data being entered) to change color based off the date/time entered in cell B.
I have it set up that the date and time automatically appears in cell B after a selection is made in cell A from a drop down list.

if the date/time in cell B is between today 6am and 630pm then I would like cells A-D in that row to turn a shade of yellow
if the date/time in cell B is between today 631pm and (tomorrow technically) 559am then I would like cells A-D in that row to turn a shade of blue.

Its pretty much information entered for a matinee shift between 6am and 630pm would be yellow and information entered in for an evening shift between 631pm and 559am need to be blue. I will attach my spreadsheet if it will help. I was able to get it to work for the evening but not the matinee using a CF.

Any exact formula I can enter in to use would be greatly appreciated!!

Hi,

It would have been a little more obvious if you had unhidden the Notes sheet! - I assume that's the one you're talking about.

What about times between 00:00 today and 6:00 today?

No, I was merely asking what colour (if any) you wanted for times TODAY before 6:00.

You've told us about 6:00 - 18:30 today and between 18:30 and 6:00 TOMORROW but it's not clear whether you want to paint a cell that has a time of say 4:00 TODAY.

If the date/time from cell B is from today 6:00am and 6:30pm then I would like cells A-D to all be yellow for that row.
If the date/time from cell B is from today 6:31pm and (tomorrow) 5:59am, I would like cells A-D to all be blue for that row.

It's business days that I am working with. So a matinee shift would be from 6am-630pm and an evening shift from 631pm to 559am on the following day.

Yes I understand that, but what about the time slot from midnight to 6:00 TODAY, or would a time in that slot never appear?

Hi,

The Yellow CF is

Formula:

Please Login or Register  to view this content.

and the blue

Formula:

Please Login or Register  to view this content.

Just add a logical AND condition. i.e.

Formula:

Please Login or Register  to view this content.