conditional format

[JOEE1979]

I have a conditional format (cell value of N4:N27 is greater than N1 then highlight cell) but it dont work, not sure why.

Weekday Bus Cycling - January 2023 - steeprock.xlsx
	N
1	19:17:02
2	Sign on
3
4	10:05:00
5	10:40:00
6	11:50:00
7	12:05:00
8	12:19:00
9	12:50:00
10	13:20:00
11	13:30:00
12	13:35:00
13	13:55:00
14	14:05:00
15	14:20:00
16	14:30:00
17	14:45:00
18	15:05:00
19	21:30:00
20
21
22
23
24	10:45:00
25
26
27
Table 1

Cell Formulas
Range	Formula
N1	N1	=NOW()

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
N4:N27	Cell Value	>=$N$1	text	NO

 

[Skyybot]

Try changing the >=$N$1 to >=Now()

 

[JOEE1979]

Try changing the >=$N$1 to >=Now()

didnt work

 

[Skyybot]

didnt work

Dang. Stand by.

 

[Skyybot]

Is that column formatted as Time?

 

[JOEE1979]

Is that column formatted as Time?

yes

 

[JOEE1979]

hh:mm:ss

 

[Peter_SSs]

NOW() includes the date and time so will be something like 44982.4832
Therefore your other time values in col N will never be greater than N1
Try this formula in N1 instead

=MOD(NOW(),1)

 

[JOEE1979]

NOW() includes the date and time so will be something like 44982.4832
Therefore your other time values in col N will never be greater than N1
Try this formula in N1 instead

=MOD(NOW(),1)

worked, thanks

 

[Peter_SSs]

You're welcome. Thanks for the confirmation.