In the formula field, I type =, A3, equal to C3. Now conditional formatting drop-down, New rule, New Formatting Rule dialog box appears, select option “Use a Formula to determine which cells to Format”. In my selection, the first cell is selected. I select all the data here you have to make sure that the first cell in the range is selected. You can do it using the “Equal To” rule in the “Highlight Cells Rules” list. Say I want to highlight the cells that have value 38. In the next worksheet, you see there are some values in this data range. ![]() With another example, you will get clear the concept. So if I copy this cell format, and paste format in the next cell, the formula will now refer to cell B4. One thing, you have to understand very clearly here: when I copied the formatting from this cell to other cells, the format is copied to other cells using relative references. You see the cells that have texts, are highlighted with Boldface and Red color Font. Now I copy the Format from this cell and paste the format to other cells in the range. The value of cell A3 is not a text, so this function returns False and the cell is not formatted. If the function returns False, then no format will be applied on a cell. If this function returns true, then the format you set here will be seen in the cell. I click on the Format Button, Format Cells dialog box appears, I use Bold Font style, Font color Red. The ISTEXT function returns True if the argument of the function is a text value. Then I type ISTEXT, open parenthesis, type cell reference A3, closing parenthesis. ![]() I input equal sign you know an equal sign is a must thing to write a formula. So, the formula that you can use in this field must return either true or false. If it returns True, then the cell will be formatted. You have to put the formula in this field. You see there is a field under: “Format values where this formula is true”. In the dialog box, select the option: “Use a Formula to determine which cells to format”. I select the first cell within the range, then click on the conditional formatting drop-down, then click on New Rule. ![]() You cannot use the techniques that you have learned so far to perform this job. For example, say, I am telling you to format the cells differently that have texts. The range has some values and has some texts. You see a piece of the data range in this worksheet. In this video tutorial and in the next video, we shall learn how you can format cells using formulas. We have used Data bars, Color Scales and Icon Sets to format cells conditionally. #OPENOFFICE CONDITIONAL FORMATTING FORMULA EXAMPLE HOW TO#We have also learned how to highlight some top or bottom values. We have used these Greater than, Less than, Between, Equal to, and other formatting rules. We have so far learned how to highlight cells based on the cell content. You can format any cell using conditional formatting rules. #OPENOFFICE CONDITIONAL FORMATTING FORMULA EXAMPLE DOWNLOAD#Download Exercise Files, Video Summary & Practice Problems
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |