Forum Discussion
Jessssssssss
Jan 08, 2025Copper Contributor
Conditional formatting time
good morning.
i have it set up in my spreadsheet to highlight anything over 15 minutes (time is entered as 0:15) and its working fine.
but it is also highlighting everything that is 0:00 and i can't figure out to exclude these so is there a different formula to use?
currently i am using
=L11>time(0,15,0)
What happens if you format the cells with the times as General or as Number?
Are all values less than 1 or are there values greater than or equal to 1?