In a spreadsheet I want to compare a time with now()
I want with a conditional format cell colors red when the time is due
But i noticed there is no way google sheets let me compare with a condition a given time with now. (See example in the link where I use 3 give times)
What is the proper way to compare a time with now()
A1 = 10:15
A2 = 10:20
now() => 10:10
**output TRUE, expected value FALSE
**output TRUE, expected value TRUE
Now() has a date element it is today. While the times do not. So it will always be greater.
You need to remove the date which is a whole number. One method is:
So your formula will be:
One note: if all you want is True/False then you do not need the IF():
Which will return
FALSE on its own.