From The Document Foundation Wiki
Jump to navigation Jump to search
  1. Select cells with students' names
  2. Open conditional formatting Format ▸ Conditional ▸ Manage
  3. Press Add
  4. In first dropdown menu select Formula is
  5. Enter the deadline formula: B1>=(DATE(2015;5;4)+TIME(18;0;0))
  6. Select appropriate style and it is done.