Full feature free trial 30-day, no credit card required! Get It Now Kutools for Excel- Includes more than 300 handy tools for Excel. Click the Fill Color button on the Home tab, and then specify a highlight color from the drop down list. And then all cells with the entire rows which contain the specific text or value are selected.ĥ. In the second Select Specific Cell dialog box, click the OK button. (2) In the Specific Type section, click the first box and specify the Contains from the drop down list, and then enter the specific text into the following box.Ĥ. (1) Check the Entire row in the Selection type section In the opening Select Specific Cells dialog box (see above screenshot), Click the Kutools > Select > Select Specific Cells.ģ. Select the column where you will find out cells if contain specific text or value.Ģ. Full feature free trial 30-day, no credit card required! Free Trial Now!ġ. With Kutools for Excel's Select Specific Cells feature, we can select the rows if cells contain specific text or value, and then highlight these rows easily in Excel. Then all rows containing the specific content cells in the selected range are highlighted. Click OK button to close the New Formatting Rule dialog box.
Go to the Fill tab, specify a background color, and click the OK button.ĥ. Now the Format Cells dialog box is opening. (3) If you want to highlight rows if cells begin with specific text, you need to enter =LEFT($B2,5)="Apple" or to highlight rows if cells end with specific text, enter =RIGHT($B2,5)="Apple".Ĥ. (2) If you want to highlight rows if cells are blank, enter =$B2="" in the Step 3-(2). And this formula can only find out cells only containing the specific text or value. (1) In the formula of =$B2="Apple",$B2 is the cell you will check if contains the specific text or value, and "Apple" is the specific text, you can change them as you need. (2) In the Format values where this formula is true box, enter =$B2="Apple" (1) Click to select the Use a formula to determine which cells to format in the Select a Rule Type box In the coming New Formatting Rule dialog box, (see the second screenshot above): Click the Home > Conditional Formatting > New Rule. Select the purchase table without its column headings.Ģ. To highlight entire rows of cells containing the specific text, value or just be blank with the Conditional Formatting command in Excel, you can do as following:ġ.