From The Document Foundation Wiki
Jump to navigation Jump to search
  1. First of all select cells with students' names
  2. Open conditional formatting Format ▸ Conditional ▸ Manage
  3. Press Add
  4. In first dropdown menu select Formula is and type B1<4
  5. Select appropriate style and it is done.