Ask Your Question

Function Domains/Conditional Formatting [closed]

asked 2013-08-06 21:40:21 +0100

ajrlegits gravatar image

I have two questions about LibreOffice Calc:

  1. Is there a way to set a variable domain for a function? For example, if I want a function to find the median of all the values in a column, how can I get the function to adjust its domain automatically whenever I add a new piece of data to the column? I want to avoid having to change the function from =MEDIAN(B1:B10) to =MEDIAN(B1:B11) (and so on) every time I add a row. Better yet, is there a way to set the domain to "every cell within the column that contains a value"?

  2. If I have a set of reference data in row 1 and actual data in rows 2–10, is it possible to use conditional formatting to set a different formatting style for each cell in rows 2–10 based on the relationship of each piece of data to the reference data in row 1? I'm not sure how to explain this concisely.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-05 23:26:39.756995

1 Answer

Sort by » oldest newest most voted

answered 2013-08-06 23:52:58 +0100

m.a.riosv gravatar image
  1. You can set up the range as long as you like, empty cells are not part of the calculation.
    or set up Menu/Tools/Options/LibreOffice calc/General - Expand references when new columns/rows are inserted

  2. image description

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2013-08-06 21:40:21 +0100

Seen: 573 times

Last updated: Aug 06 '13