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
0 kommentar(er)
