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.

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!!!