View Single Post
  #2   Report Post  
Marc W.
 
Posts: n/a
Default



"snitz" wrote:

Am trying to apply conditional formatting to columns of times. The numbers
are in 24-hour clock format - 00:15:23.
I would like to bold the times that are less than 15 minutes.
Entering in 00:15:00 as the"less than" amount hasn't work. When i do it
anyway.

Thanks for all advice.
jb



Hi,

Set Conditional Formatting like this ,
Formula is, =IF(MINUTE(D28)<15,TRUE,FALSE)


Regards,
Marc