"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
|