![openoffice conditional formatting for highest number openoffice conditional formatting for highest number](https://i.ytimg.com/vi/9QOwB5upWPY/hqdefault.jpg)
- Openoffice conditional formatting for highest number how to#
- Openoffice conditional formatting for highest number download#
Openoffice conditional formatting for highest number download#
So now, whenever you type a keyword in cell B1 and press Enter, it highlights all the rows that have the cells that contain that keyword.īonus Tip: If you want to make the search case sensitive, use the FIND Function instead of SEARCH.Ĭlick here to download the example file and follow along.
![openoffice conditional formatting for highest number openoffice conditional formatting for highest number](https://usermanual.wiki/Openoffice-Org/OpenofficeOrgOpenoffice32CalcGuide777740.1118677903/asset-15.png)
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.
![openoffice conditional formatting for highest number openoffice conditional formatting for highest number](http://2.bp.blogspot.com/-Hr4CPvmvxfc/VgStJLDHC6I/AAAAAAAACLs/9TEtiEdi3Yo/s1600/ooo_calc_alt_rows_0.png)
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 If 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.
![openoffice conditional formatting for highest number openoffice conditional formatting for highest number](https://doc.odoo.com/doc_static/5.0/_images/writer_report.png)
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.
Openoffice conditional formatting for highest number how to#
I will show you how to search and highlight only the matching cells in a dataset.