In this article, we will learn how to highlight rows that meet criteria. This technique will be based on Conditional Formatting & regular formulas.
The formulas we are going to use are IF, ISBLANK, ISNUMBER, SEARCH together to get the output.
Let us take an example:
We have Product data wherein the text or number entered in the searchbox will trigger the formula to highlight the entire rows.
The objective is to highlight the entire rows which match value in cell B2.
We need to follow these steps:
The formula in conditional formatting will highlight every row that matches value in cell B2
If we enter Paper in cell B2; we get:
If we enter text from SKU column; we get:
In this way, we can highlight the entire rows if the text is found in any of the data table.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.