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 cr...

excel

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

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.
  - Stephanieeee
    Copper Contributor
    Nov 29, 2022
    Thank you!!!