Conditional format based on time

[Fegal]

Hi All

I need to highlight F9 if the current time is less than 1 hour before F9.
hope that makes sense!

Fatigue 1.xlsx
	B	C	D	E	F
3	OP NAME
4	CURRENT DATE	CURRENT TIME
5	24/03/2024	20:12
6
7		End of rest pre deployment	Deployed
8	Deployed members	Date & Time	Date & Time	Pre-deployment wake time	17 Hour limit
9	1	23/03/2024 8:00 AM	23/03/2024 6:00 PM	10	24/03/2024 1:00 AM
Sheet1

Cell Formulas
Range	Formula
B5	B5	=TODAY()
C5	C5	=NOW()
E9	E9	=TEXT(D9-C9,"[H]")
F9	F9	=IF(C9="","",C9+17/24)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
F9	Expression	=HOUR(F9)=HOUR(NOW)	text	NO

 

[Fegal]

Actually ill just extend it out so the format clears if I9 has a time in it

Fatigue 1.xlsx
	B	C	D	E	F	G	H	I
8	Deployed members	Date & Time	Date & Time	Pre-deployment wake time	17 Hour limit			Date & Time
9	1	23/03/2024 8:00 AM	23/03/2024 6:00 PM	10	24/03/2024 1:00 AM	7		24/03/2024 1:00 AM
10	2
Sheet1

Cell Formulas
Range	Formula
E9	E9	=TEXT(D9-C9,"[H]")
G9	G9	=TEXT(I9-D9,"[h]")
F9:F10	F9	=IF(C9="","",C9+17/24)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
F9	Expression	=HOUR(F9)=HOUR(NOW)	text	NO

 

[Fegal]

Bump.. please