Excel Novice need help with colour blocking between start and end time (hourly values)

[Stephanieeee]

Hi Everyone... 

Thank you in advance... 

I am useless at Excel, very basic understanding and am trying to create a tool to help me understand individual coverage in a day. 

I am trying to create a simple 0500-2200 timeframe spreadsheet where I input a start time and end time, the sheet will automatically colour in a block between that start time and end time. 

Can anyone shed any light. 

[#2]

@Stephanieeee 

=(A5>=$B$2)*(A5<=$C$2)

You can try this rule for conditional formatting. The start time and end time are entered in cells B2 and C2 in this example.

[#3]

Hiya, thank you so much for replying.... This is the basic format of what I'm trying to achieve @OliverScheurich 

[#4 · Accepted solution]

@Stephanieeee 

=(C$1>=$A2)*(C$1<=$B2)

This is the rule for conditional formatting in the screenshot.

 

[#5]

Thank you!!!