conditional formatting with time format

[kelvin_9]

hi all,
if i want to enter a time with format([$-en-US,1]hh:mm) in A1, how can i easily track in column B, if time is larger than A1, bold/color the cell automatically?

thanks

 

[James006]

Hi,

You can use following formula : =B1>$A$1

Hope this will help

 

[kelvin_9]

Hi,

You can use following formula : =B1>$A$1

Hope this will help

thanks james
am i wrong?

 

[James006]

Have you tested the formula ...?

 

[kelvin_9]

Have you tested the formula ...?

it's good now, i messed sth, i am sorry.
thanks james in advance

 

[James006]

You are welcome