SOLVED

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

Copper Contributor

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

Hi Everyone...

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.

4 Replies

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

``=(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.

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

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

best response confirmed by Stephanieeee (Copper Contributor)
Solution

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

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

This is the rule for conditional formatting in the screenshot.

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

Thank you!!!
1 best response

Accepted Solutions
best response confirmed by Stephanieeee (Copper Contributor)
Solution

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

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

This is the rule for conditional formatting in the screenshot.