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: A1>=(DATE(2016;2;1)+TIME(17;0;0)) A1>=(DATE(2016;2;1)+17/24) if you put the dead line in a cell e.g. D1, so it's possible change it without edit CF with Formula is. A1>=D1 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.