Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenThu, 04 Oct 2018 03:30:14 +0200Conditional Formatting text to number valuehttps://ask.libreoffice.org/en/question/167615/conditional-formatting-text-to-number-value/ Hello community,
I have what may be a complicated question.
So basically i have switched from OpenOffice to LibreOffice because i heard they can do more than 3 conditions on a cell. I need to do at least 5 conditions at this stage.
What I am doing is a spreadsheet of Golf scores for every player in our local club showing the best score each player has had on each hole throughout the year, I have basically all the numbers worked out. If your 1 under par the entered number turns cell blue, Par remains normal, bogey turns cell red and so on. BUT if a player has a "maxed out score" for a paticular hole I wish to enter a "/" (without the quotes) have the cell change colour (easy) BUT also have the "/" represent the maximum number you can have on that paticular hole for it to count... Example if a player didnt score less than 7 on a hole i would enter / and have it change colour so they know they need to improve on that paticular hole. But I want the / to remain in the cell but have a value of 8 (maximum score) so it adds up in the end results...
At the moment i have to count and type the purple scores manually, i just wish to press / and have a hidden number add up at the end. I dont wish to have numbers in the purple cells. Only /
Sorry if I didnt explain this too well, but i hope the picture i attached will shine some light on what im asking and if it is posbible. See Peter near the bottom for an example.
Thanks in advance.![image description](/upfiles/15386162948271097.png)BradlpopsThu, 04 Oct 2018 03:30:14 +0200https://ask.libreoffice.org/en/question/167615/Formatting cells in a series in Google Docs/Excelhttps://ask.libreoffice.org/en/question/96770/formatting-cells-in-a-series-in-google-docsexcel/I don't know how to phrase this so here is what I'm trying to do: I have a series of cells that I need to increase by 50 every two cells.
So here is my data: Cell 1: 0, Cell 2: 50 (+50), Cell 3: 100 (+50), Cell 4: 200 (+100), Cell 5: 300 (+100), Cell 6: 450 (+150), Cell 7: 600 (+150), etc.
So is there a way to format the cell allowing the sequential increase to be every two cells instead of after every one? Sorry if this is confusing or not phrased well I wasn't very sure on how to explain this. Also to anyone who takes a look at this question, thanks for your time.GrimmjaxxTue, 23 May 2017 08:42:33 +0200https://ask.libreoffice.org/en/question/96770/