Forum Discussion

Stephanieeee's avatar
Stephanieeee
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's avatar
    OliverScheurich
    Nov 29, 2022

    Stephanieeee 

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

    This is the rule for conditional formatting in the screenshot.

     

OliverScheurich's avatar
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's avatar
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's avatar
    OliverScheurich
    Gold Contributor
    Nov 29, 2022

    Stephanieeee 

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

    This is the rule for conditional formatting in the screenshot.

     

    • Stephanieeee's avatar
      Stephanieeee
      Copper Contributor
      Nov 29, 2022
      Thank you!!!

Resources