my problem seems simple but I’m having a hard time googling it.
I have a sheet that has, say, 50 rows for employees in different locations.
On the sheet is a cell containing a selection list of the different possible locations.
Now I would like to show and hide rows, based on what value is selected in my selection list.
I have managed to apply conditional formatting this way, and it works. So, example:
Selection List is in C2 and contains Berlin, Munich, Hamburg to select from.
Employees start from say row 10. I select (by mouse) rows 10,11,15,21 for four employees in Berlin. I give these rows conditional formatting by doing
format → conditional formatting → condition → formula is → $C2=“Berlin” → apply style → bold text.
Instead of bold text I’d like them to just get hidden. Afaics there’s no way doing it via the “styles and formatting” method? How can I apply this condition and have rows shown or hidden?
So, what I want is:
If C2 is “Berlin”, then Show/Hide Rows XX, NN, YY or
hide this row if C2 is “Berlin” applied to the lines. Lines need not be determined by some value they contain (although that would be nice, too), my data is manageable enough for me to select the lines concerned manually.
Libreoffice Calc 184.108.40.206