Translations:Faq/Calc/146/6/en

    From The Document Foundation Wiki
    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.