Interested in learning more about Excel VBA MrExcel will teach you how to use Microsoft Excel VBA. Check out our site for more information about Excel VBA tutorials. How to highlight row if cell contains textvalueblank in Excel Select entire rows if cells contain certain textvalues in Excel. Kutools for Excels Select Specific Cells feature can help you quickly select the cells, entire rows, or entire columns if cells contains the certain value in Excel. Click for 6. 0 day free trial Highlight row if cell contains specific textvalueblank with Conditional Formatting 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 1. Select the purchase table without its column headings. Excel Highlight Active Cell Color' title='Excel Highlight Active Cell Color' />Use Excel conditional formatting to color rows, hide duplicates, highlight items or hide errors. Click the Home Conditional Formatting New Rule. See the first screenshot below 3. In the coming New Formatting Rule dialog box, see the second screenshot above 1 Click to select the Use a formula to determine which cells to format in the Select a Rule Type box 2 In the Format values where this formula is true box, enter B2Apple 3 Click the Format button. Notes 1 In the formula of B2Apple,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. And this formula can only find out cells only containing the specific text or value. If you want to highlight rows if cells are blank, enter B2 in the Step 3 2. If you want to highlight rows if cells begin with specific text, you need to enter LEFTB2,5Apple or to highlight rows if cells end with specific text, enter RIGHTB2,5Apple. Now the Format Cells dialog box is opening. Go to the Fill tab, specify a background color, and click the OK button. Click OK button to close the New Formatting Rule dialog box. Then all rows containing the specific content cells in the selected range are highlighted. Highlight row if cell contains specific textvalue with Kutools for Excel. With Kutools for Excels Select Specific Cells feature, we can select the rows if cells contain specific text or value, and then highlight these rows easily in Excel. Select the column where you will find out cells if contain specific text or value. Click the Kutools Select Select Specific Cells. In the opening Select Specific Cells dialog box see above screenshot,1 Check the Entire row in the Selection type section 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. Click the OK button. In the second Select Specific Cell dialog box, click the OK button. And then all cells with the entire rows which contain the specific text or value are selected. Click the Fill Color button on the Home tab, and then specify a highlight color from the drop down list. Free Trial Kutools for Excel Now Highlight entire row if cell contains one of specific values in another column. Sometimes you may need to highlight the entire row only if its cell contains one of specific values in another column. Kutools for Excels Compare Ranges utility provides another workaround to highlight entire rows if cells contain one of specific values easily. Click Kutools Select Select Same Different Cells. In the Select Same Different Cells dialog box, Please do as follows 1 In the Find values in box, please specify the Column whose cells you will check if containing one of specific values 2 In the According to box, please specify the column containing the specific values 3 In the Based on section, please check the Each row option 4 In the Find section please check the Same Values option 4 In the Processing of results dialog box, please check the Fill backcolor option and specify the fill color 5 Check the Select entire rows option. Click the OK button to apply this utility. And then another Compare Ranges dialog box comes out and show us how many rows have been selected. Just click the OK button to close it. And then you will see if a cell contains one of specific values in another column, the entire row containing this cell will be highlighted and filled with the specific color. Free Trial Kutools for Excel Now. Demo highlight row if cell contains certain value or one of specified values. Tip In this Video, Kutools tab and Enterprise tab are added by Kutools for Excel. If you need it, please click here to have a 6. Automatically highlight active row and column with Kutools for Excel. When selecting a cell in Excel, normally only the active cell is highlighted. Adobe Flashplayer 9 Rpm more. However, Kutools for Excels Reading Layout utility can automatically highlight the entire row and column of active cell automatically. Click for 6. 0 day free trial Related Articles. Recommended Productivity Tools Bring handy tabs to Excel and other Office software, just like Chrome, Firefox and new Internet Explorer. Amazing Increase your productivity in 5 minutes. Dont need any special skills, save two hours every day New Features for Excel, Make Excel Much Easy and Powerful Merge CellRowsColumns without Losing Data. Combine and Consolidate Multiple Sheets and Workbooks. Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion. Count by Colors, Paging Subtotals, Advanced Sort and Super Filter,More SelectInsertDeleteTextFormatLinkCommentWorkbooksWorksheets Tools.