Frequently asked questions - Calc

    From The Document Foundation Wiki
    < Faq‎ | Calc


    Applying conditional formatting to adjacent cells is not so hard, as it may seems.

    First example

    Screenshot

    Let's try to highlight students with bad marks:

    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.

    Note that $ sign plays here the same role as in regular cells.

    Example with deadlines

    Now let's imagine our students were to make their hometask by the 4th of May, till 18:00. Let's highligh names of those who didn't meet the deadline.

    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.

    An alternative approach would be to put our deadline in anothe cell, the formula would be simplier and it is much easier to move our deadline.

    • Let's put out deadline value to D1. (D1=04.05.2015 18:00:00)
    • Enter simple formula: B1>=D$1