Apply custom formula if time falls between between two times

[AR_2222]

Hi,

I want to highlight the entire row if a time in column B falls between 00:00:00 and 06:30:00 (as an example). I can highlight the single cells but not the row. I've read about 'Custom formula is' but I can't seem to find what the custom formula code is for 'in between' two times. I've tried a few variations from ideas I've found on here, but I can't seem to get it right.

Could someone help me out please?

Thank you.

 

[JamesCanale]

MrExcelPlayground6.xlsx
	A	B	C	D	E	F	G
1	Name	Time	Thing1	Thing2	Thing3		12:00:00 AM
2	Fred	7:30	A	A	A		6:30:00 AM
3	Harry	6:00	B	B	B
4	John	20:00	C	C	C
5	Mary	1:30	D	D	D
6	Sally	12:00	E	E	E
Sheet25

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:E6	Expression	=AND($B2>=$G$1,$B2<=$G$2)	text	NO

Another guy on here used this ingenious way of doing it:

MrExcelPlayground6.xlsx
	A	B	C	D	E	F	G
1	Name	Time	Thing1	Thing2	Thing3		12:00:00 AM
2	Fred	7:30	A	A	A		6:30:00 AM
3	Harry	6:00	B	B	B
4	John	20:00	C	C	C
5	Mary	1:30	D	D	D
6	Sally	12:00	E	E	E
Sheet25

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:E6	Expression	=$B2=MEDIAN($G$1:$G$2,$B2)	text	NO