Jump to content

LibreOffice / Nextcloud Office – "Due Tasks" Conditional Formatting: Revision history

Diff selection: Mark the radio buttons of the revisions to compare and hit enter or the button at the bottom.
Legend: (cur) = difference with latest revision, (prev) = difference with preceding revision, m = minor edit.

25 February 2026

  • curprev 07:0007:00, 25 February 2026 BabiSender talk contribs 3,951 bytes +3,951 Created page with "== LibreOffice Calc – "Due Tasks" Conditional Formatting == Highlight whole rows in '''red''' when a task is due and must be acted on. ---- == Goal and Logic == === Core Conditions === For a row to be considered '''due''', two things must be true: ; Target Date condition : The '''Target Date''' in column <code>E</code> must be '''today or earlier'''. Past dates have smaller numeric values than today, so the check is: <code>TODAY() >= TargetDate</code> ; Is It Du..."