Forum Discussion
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 ...
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?