Extract Text, Add Text, Remove by Position, Remove Space Create and Print Paging Subtotals Convert Between Cells Content and Comments.Exact Copy Multiple Cells without changing formula reference Auto Create References to Multiple Sheets Insert Bullets, Check Boxes and more.Select Duplicate or Unique Rows Select Blank Rows (all cells are empty) Super Find and Fuzzy Find in Many Workbooks Random Select.Merge Cells/Rows/Columns without losing Data Split Cells Content Combine Duplicate Rows/Columns.Super Formula Bar (easily edit multiple lines of text and formula) Reading Layout (easily read and edit large numbers of cells) Paste to Filtered Range.Reuse: Quickly insert complex formulas, charts and anything that you have used before Encrypt Cells with password Create Mailing List and send emails.The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80% Kutools for Excel: with more than 300 handy Excel add-ins, free to try with no limitation in 30 days. If you have Kutools for Excel, with its Super Filter utility, you can quickly filter the cells which contains specified text values, and then highlight them at once.

And then click OK > OK to close the dialogs, all the cells which contain any one of the specific list cell values are highlighted at once, see screenshot:įilter cells contains specific values and highlight them at once Go to the Format Cells dialog box, and choose one color to highlight the cells under the Fill tab, see screenshot:Ĥ. (2.) Then enter this formula: =SUM(COUNTIF(A2,'*'&Mylist&'*')) ( A2 is the first cell of the range you want to highlight, Mylist is the range name you have created in step 1) into the Format values where this formula is true text box ģ. (1.) Click Use a formula to determine which cells to format under the Select a Rule Type list box Then select the cells that you want to highlight, and click Home > Conditional Formatting > New Rule, in the New Formatting Rule dialog box, finish the below operations:

First, please create a range name for the specific words list, select the cell text and enter a range name Mylist (you can rename as you need) into the Name box, and press Enter key, see screenshot:Ģ. In fact, the Conditional Formatting can help you to solve this job, please do with the following steps:ġ.

It may be easy for us to highlight rows based on a specific value, this article, I will talk about how to highlight cells in column A depending if they are found in the column D, which means, if the cell content contains any text in a specific list, then highlight as left screenshot shown.Ĭonditional formatting to highlight the cells contains one of several valuesįilter cells contain specific values and highlight them at once

Conditional formatting excel 2016 mac