Created attachment 121112 [details]
where to add
Date conditional formatting presets do not have useful options like Date later (or before) then "$TIME".
For example my project's deadline is 01.02.2016 17:00. I want to highlight cells, which have time more then this as RED. Currently I need to enter long formula:
OR(A1>DATE(2016;2;1); AND(A1>=DATE(2016;2;1); HOUR(A1)>16))
which is absolutely unhandy.
Hi @Yan, thanks for reporting.
I would not expect is implemented in this way.
But I think you can use simpler formulas for what you like:
if you put the dead line in a cell e.g. D1, so it's possible change it without edit CF with Formula is.
with Cell value is
[greater than or equal to] D1
Yan: are you happy with the solution in comment 1?
Yes, your solution is much easier, but I still think that adding these two entries to data list in cond formatting is necessary
Actually I think it is a good proposal. The only open point is how to represent a date time in the UI and how to parse it as well as how to implement the OOXML export.