条件格式化整行如果单元格包含文本 [英] conditional formatting entire row if cell contains text

问题描述

我有一个excel表，我试图使用条件格式，但似乎没有像我想要的那样工作。

I have an excel sheet where I'm trying to use conditional formatting but it doesn't seem to work as I would like it to.

似乎是虽然任何公式都不会工作，因为我不希望单元格匹配TBC，但包含它。

It seems as though any formula won't work as I don't want the cell to match TBC, but contain it.

总之，我正在寻找：

如果D2包含TBC，则突出显示整行

If D2 Contains "TBC" then highlight the whole row

我已经通过Google尝试了大约10个建议，同时也是Stack Overflow，但是似乎你

I've tried around 10 suggestions through Google and also Stack Overflow but it seems as thou

注意：每个单元格将具有不同的值，即D2具有1截图TBC，D3具有5截图TBC。因为他们都会有不同的价值观，但都包含缩写TBC我正在寻找这个词。

Note: Each cell will have different values, i.e. D2 has "1 screenshot TBC" and D3 has "5 screenshots TBC". As they will all have different values but all contain the abbreviation "TBC" I am trying to search for that word.

任何可以提供的帮助或建议将不胜感激。

Any help or advice that could be offered will be greatly appreciated.

提前谢谢你的时间！ ：）

Thank you in advance for your time! :)

Amandip

推荐答案

选择整个表格，首页>样式 - 条件格式，新规则...，使用公式确定要格式化的单元格和格式在此公式为真的值：：

Select your entire sheet and HOME > Styles - Conditional Formatting, New Rule..., Use a formula to determine which cells to format and Format values where this formula is true::

=FIND("TBC",$D1)

格式化... ，选择您选择的颜色填充（高亮），确定，确定。

Format..., select colour Fill (highlight) of your choice, OK, OK.

如果您希望此大小写不敏感，请将查找更改为 SEARCH 。

Change FIND to SEARCH if you want this case insensitive.

这将触发喜欢的 ATBCX 。

这篇关于条件格式化整行如果单元格包含文本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！