6/18/2023 0 Comments Libre calculatorWhere 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. 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 Comments
Leave a Reply. |