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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |