Frequently asked questions - Calc

From The Document Foundation Wiki
< Faq‎ | Calc
Jump to: navigation, search

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

Fisrt 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 formatting ▸ Manage
  3. Press Add
  4. In first dropdown menu select Formaul 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 formatting ▸ Manage
  3. Press Add
  4. In first dropdown menu select Formaul 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