Conditional formatting

[BBV123]

Hi Community, I'm trying to prepare a schedule table for 24 hours for different days

I used this formula for my table=DATE(2024,5,10) + SEQUENCE(1,96,0,1)/(24*4) and I'm using conditional formatting to highlight the cells in the table. The formula for my conditional formatting is =AND($C5<=$F$14,$D5>=F$14,$E5="Drive"). When my start time is 0:00 and end time is 00:15, it works perfectly fine. However, when my start time is 0:15 and end time is 0:30, it doesn't highlight my table as expected. How will resolve this issue. Appreciate your support on this.

Also, is there any way I can have two inputs on a single row? For instance, if my start time is 00:00 and end time is 00:45, and my status is 'drive,' it will highlight my table with the color corresponding to the status. Now, if during another time, from 01:15 to 02:15, my start time is 01:15 and end time is 02:15, and my status is 'rest,' then it should highlight both 'drive' and 'rest' based on the corresponding time inputs on a single row.

 

[awoohaw]

try this:

Book1
	A	B	C	D	E	F	G	H	I	J	K
1
2
3
4			S Time	E Time	St
5			00:15:00	00:30:00	Drive
6
7
8
9						00:00:00	00:15:00	00:30:00	00:45:00	01:00:00	01:15:00
10					Day1
11					Day2
12					Day3
13
14					building cf	FALSE	TRUE	TRUE	FALSE
15
Sheet4

Cell Formulas
Range	Formula
F9:CW9	F9	=SEQUENCE(1,96,0)*(15/(60*24))
F14:I14	F14	=AND(F$9>=$C$5,F$9<=$D$5,$E$5="Drive")
Dynamic array formulas.

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
F10:CW12	Expression	=AND(F$9>=$C$5,F$9<=$D$5,$E$5="Drive")	text	NO