如果任何单元格包含指定的文本，则条件格式化整行

I'm trying to use conditional formatting to highlight all rows that contains a specific value in any of the cells of that row.

我正在尝试使用条件格式来突出显示该行的任何单元格中包含特定值的所有行。

For example, if this is the spreadsheet:

例如，如果这是电子表格：

     A            B            C             D           E
1    Town         Baseball     Basketball    Football    Soccer
2    Barksdale    Cardinals    Lions         Tigers      Lightning
3    Clinton      Bluejays     Bears         Cardinals   Tornadoes
4    Denton       Giants       Tigers        Blues       Hornets

I would like to highlight every row that contains 'Blue' anywhere in the row. In this case, it should highlight the "Clinton" row, because it has "Bluejays", and the "Denton" row, because it has "Blues".

我想突出显示行中任何位置包含“蓝色”的每一行。在这种情况下，它应该突出“克林顿”行，因为它有“蓝鸟”和“丹顿”排，因为它有“蓝调”。

I'm trying this as the formula:

我正在尝试这个公式：

=SEARCH("Blue",A1)

And I'm applying it to:

我正在申请：

=$1:$1048576

Unfortunately, that highlights the specific cell containing "Blue", but not the entire row.

不幸的是，它突出显示包含“蓝色”的特定单元格，但不是整行。

I've seen posts about formatting the entire row based upon the value of one cell, and I've seen posts about formatting one cell based upon the value of other cells in the row, but I can't seem to figure out how to combine those to work in my situation.

我已经看到有关根据一个单元格的值格式化整行的帖子，我看过有关根据行中其他单元格的值格式化一个单元格的帖子，但我似乎无法弄清楚如何结合那些在我的情况下工作。

Any ideas?

有任何想法吗？

1 个解决方案

#1

Try this formula for conditional formatting:

尝试使用此公式进行条件格式化

=COUNTIF(1:1,"*blue*")