Note: The reason it highlights the entire row and not just the matching cell is that we have used a $ sign before the column reference ($B4). If you want it to work for Sales Rep name, you need to change the formula to =$C4=$B$1 If you enter a Sales Rep name here, it will not work. Note that this will only check for the item column. The above steps would search for the specified item in the dataset, and if it finds the matching item, it will highlight the entire row. Here are the steps to search and highlight the entire row: If you want to highlight the entire row instead of just the matching cells, you can do that by tweaking the formula a little.īelow is an example where the entire row gets highlighted if the product type matches the one in cell B1. Search and Highlight Rows with Matching Data #Openoffice conditional formatting not working downloadIf it isn’t the same, the formula returns FALSE and nothing happens.Ĭlick here to download the example file and follow along. If it’s the same, the formula returns TRUE and the cell gets highlighted. In the above example, we check each cell using the formula =A4=$B$1Ĭonditional Formatting checks each cell and verifies it the content in the cell is the same as that in cell B1. It will highlight the matching cells in the dataset that contain the keyword in B1.Ĭonditional Formatting gets applied whenever the formula specified in it returns TRUE. Now type anything in cell B1 and press enter.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |