Your cursor will change to a paint bucket. To apply the formatting you just cloned, select the cells you want to apply it to. When you do, you’ll notice that the paintbrush icon on your toolbar is selected: Look for “Clone Formatting” and select it. How do we copy the formatting and apply it to the others instead of having to repeat the process above? Select A2 and right-click.
But we want it to apply to all the cells in that list. We applied that conditional formatting to just one cell, A2. Okay, one more thing and the first part of this tutorial is done. To test it, type a lower case “x” in B2 and hit “Enter” to see if your formatting works. Click OK on that window, and let’s test our Conditional Formatting. That’s actually all we need to do for now. When you’re done, click “OK” and you’ll be taken back to the original Conditional Formatting window. Next, Strikethrough is a Font Effect, so we click on the Font Effects tab and look halfway down the screen to where it says “Strikethrough.” By default, it says “(Without).” Click on that drop-down and select “Single” (or “Double” if that’s your fancy). Since we are going with “Strikethrough,” let’s call this “Strikethrough.” We actually only need to change two things. Since we want to have the text crossed out and that isn’t one of the built-in options, we’re going to select “New Style”. If you click next to “Apply Style” where it says “Accent,” you’ll see a list of built-in formatting options:
(NOTE: If you want text or a character as part of your formula, it has to be inside quotes.) Here’s how it looks in the window:īelow that, we need to indicate how we want the formatting to change. We’re going to tell Calc to check to see if there is a lower-case “x” in B2. So, select “Formula is.” You’ll notice that the window changes and you now just have a single box next to “Formula is” where you can enter your formula:įor our very simple to-do list, our formula will be pretty simple. As the next tutorial will illustrate, you can also use the information in the same cell (e.g., A2) to change the formatting of that cell. For this one, we’re going to go with “Formula is.” The reason why we are going with “Formula is” is because we are going to use the information in a different cell, B2, to change the formatting in the current cell, A2. Those options are “Formula is” and “Date is.” This tutorial will cover two of the three options. If you click on the drop-down arrow where it says “Cell value,” you’ll see a couple of additional options: Where it says “Condition 1” is where you will build your condition statement. Right now, I have it applying to just a single cell, A2. Obviously, this can be set to a range of cells or just a single cell. At the bottom, the range of cells to which the conditional formatting will apply is included. How do I set up the conditional formatting?įirst, select the first cell (A2) that says “grocery shopping.” Then go up to “Format” on the menu and select “Conditional” -> “Condition.”Īn explanation of the window is in order. This way, I can quickly and easily discern which items are completed on my to-do list and which still need to be completed. Effectively, I am going to change the font of the tasks to “strikethrough,” which crosses out the text. If I add an “x” to the Complete column for an item, I want that item to be crossed out. Here’s how my spreadsheet looks, to begin with: Let’s say I want to use a spreadsheet as a to-do list. Let’s start with a very basic illustration. Tutorial A – “Formula Is” Conditional Formatting Then, when you enter information into your spreadsheet, the cell formatting automatically updates to reflect the information in the cell. Instead, you “program” into the spreadsheet how you want cells to look assuming they meet specific criteria. (NOTE: I’m using LibreOffice 7.2.4.1 for this tutorial.)īefore I begin, what is conditional formatting? The basic idea is that you can change the look of a cell in a spreadsheet (or many cells) based on the contents of those cells (or other cells) without having to manually change the formatting of the cells. To help get myself up to speed, I created the following tutorial so I can reference it again in the future. However, in the process, I realized that I am really a noob when it comes to conditional formatting.
#Libreoffice spreadsheet software#
I haven’t used this feature of spreadsheet software as much as I probably should, but I have a spreadsheet I have been working with a lot lately and conditional formatting has been key to helping me orient myself in the spreadsheet.
0 kommentar(er)
