Cell shading based on timeframe.

Hi try this, it should apply formatting for 14:00 to 14:59. Add a new rule for each hour you need and set colour accordingly.

Click on Conditional Formatting
Then New rule
Then "Use a formula to determine…."
=HOUR($A1)=14
Click Format and select preferred Cell Colour
Click ok
Click on Conditional formatting
Then Manage rules
Change drop down to "This Worksheet"
Select and replace text in "Applies to:" box with "=$A:$S"

Rinse and repeat for each hourly block changing hour numbers in formula and cell colours as desired.

Here's an example with the 14's and 15's set up.

Wait... I think I might be wrong.
Do you want a specific colour depending on the hour listed or on the hour since the current time?
That formula sets a colour for the particular hour..so 14:00 to 14:59 will always be red.
(BTW, on a side note, I was using column A not B for the time)
If you want a specific colour to represent hours past, as in red for 4 hours ago, then you'd need a totally different formula.
Something more like "=HOUR(NOW())-HOUR($A1)=4"

okey I see.
I tried that but its fixed, those will always be red and yellow. what i need is the color to be a refence to the hour so that whatever cell has an earlier hour to 14:00 is grey and later hours have other colours.
The catch here is that i need these colours to keep moving foward in time as the day progresses, meaning that at 15:00 everything with an earlier hour is grey and all the other colours have moved one timeslot ahead.

Here's an updated sheet using formulas like I suggested in my last post.

You are Godsend!!! This Was The Perfect Solution!!!