conditional formatting not working with "now" formula

[jbrown021286]

Dispatch Sheet vba test 3.xlsm
	A	B	C	D	E	F	G	H	I	J	K
1	Promise Time	Job	Time	Tag	Tech	A-F	G-Buffer	Shorting helper	Column1	Search	Ramy
2	12:00 PM	diag	2	3560		10:00 AM	9:30 AM	0			Weeks Hours
3		diag	1	5177				2
4		recall	1.4	8892				2			0
5		brakes	1.7	8891				2			RO. Count
6		recalls	1	5178				2
7		diag	1	6550				2			0
8		diag	1.5	5170				2			Total Hours
9		diag	1	1531				2
10		diag	1	2950				2			0
11		diag	1	8897				2
12		recalls	0.5	8894	123			2			Time
13		diag	1	2953	24			2			1:34 AM
14		60 k	2.8	8890	1			2
15		diag	1	5169	5			2		Search	Ramy
16								2			Weeks Hours
17								2
Dash Board

Cell Formulas
Range	Formula
K1,K15	K1	='data grouping'!$F$2
F2:F17	F2	=IF(OR(ISBLANK([@[Promise Time]]), ISBLANK([@Time])), "", [@[Promise Time]]-[@Time]/24)
G2:G17	G2	=IF(OR([@[A-F]]="",'data grouping'!$AG$2=""),"",[@[A-F]]-'data grouping'!$AG$2)
H2:H17	H2	=IF(AND(A2<>"", D2<>""), IF(E2<>"", 1, 0), 2)
K4	K4	='data grouping'!$F$5
K7	K7	='data grouping'!G5
K10	K10	='data grouping'!$F$7
K13	K13	=NOW()

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
J2,D2:D86	Cell Value	duplicates	text	NO
D2:D86	Cell Value	duplicates	text	NO
J16	Cell Value	duplicates	text	NO
K10:AA10	Other Type	Color scale		NO
K7:AA7	Other Type	Color scale		NO
A2:I86	Expression	=$E2<>""	text	NO
A2:I86	Expression	=$G2<$K$13	text	NO

i cant figure out why my conditional formatting formula is not working. i have a now formula in K13 and if the time in column h is less than the time in k13 i need the row highlighted. it works in a test cell with a manually entered time but always formats the cell no matter the value of h when referencing k13. any help would be appreciated. not sure if it matters but i also have a vba running that recalculates the sheet every 60 sec and a vba that causes that to run at open of workbook

 

[arthurbr]

NOW() returns date AND time. To extract time just use

=MOD(NOW(),1)

instead