Forum Discussion

Copper Contributor

Nov 29, 2022

Solved

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

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.

excel

OliverScheurich
Nov 29, 2022
Stephanieeee
=(C$1>=$A2)*(C$1<=$B2)
This is the rule for conditional formatting in the screenshot.

4 Replies

OliverScheurich
Gold Contributor
Nov 29, 2022
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.
- Stephanieeee
  Copper Contributor
  Nov 29, 2022
  Hiya, thank you so much for replying.... This is the basic format of what I'm trying to achieve OliverScheurich
  - OliverScheurich
    Gold Contributor
    Nov 29, 2022
    Stephanieeee
    =(C$1>=$A2)*(C$1<=$B2)
    This is the rule for conditional formatting in the screenshot.