https://bugs.documentfoundation.org/show_bug.cgi?id=96312
Bug ID: 96312
Summary: Add "Later then / before then" to date conditional
formatting
Product: LibreOffice
Version: 5.0.3.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 121112
--> https://bugs.documentfoundation.org/attachment.cgi?id=121112&action=edit
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.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
