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.
我有一个excel表,我正在尝试使用条件格式,但它似乎没有像我希望的那样工作。
It seems as though any formula won't work as I don't want the cell to match TBC, but contain it.
似乎任何公式都不会起作用,因为我不希望单元格匹配TBC,但包含它。
In short, I am looking for this:
总之,我正在寻找这个:
If D2 Contains "TBC" then highlight the whole row
如果D2包含“TBC”,则突出显示整行
I've tried around 10 suggestions through Google and also Stack Overflow but it seems as thou
我已经通过谷歌和Stack Overflow尝试了大约10条建议,但它似乎就像你一样
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.
注意:每个单元格将具有不同的值,即D2具有“1个屏幕截图TBC”并且D3具有“5个屏幕截图TBC”。由于它们都有不同的值,但都包含缩写“TBC”,我试图搜索该词。
Any help or advice that could be offered will be greatly appreciated.
我们将非常感谢您提供的任何帮助或建议。
Thank you in advance for your time! :)
提前感谢您的时间! :)
Amandip
Amandip
1 个解决方案
#1
4
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::
选择整个工作表和HOME>样式 - 条件格式,新规则...,使用公式确定要格式化的单元格和格式化此公式为真的值::
=FIND("TBC",$D1)
Format..., select colour Fill (highlight) of your choice, OK, OK.
格式化...,选择颜色填充(突出显示)您选择的,确定,确定。
Change FIND
to SEARCH
if you want this case insensitive.
如果您希望此不区分大小写,请将FIND更改为SEARCH。
This will trigger for the likes of ATBCX
.
这将触发像ATBCX这样的人。
#1
4
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::
选择整个工作表和HOME>样式 - 条件格式,新规则...,使用公式确定要格式化的单元格和格式化此公式为真的值::
=FIND("TBC",$D1)
Format..., select colour Fill (highlight) of your choice, OK, OK.
格式化...,选择颜色填充(突出显示)您选择的,确定,确定。
Change FIND
to SEARCH
if you want this case insensitive.
如果您希望此不区分大小写,请将FIND更改为SEARCH。
This will trigger for the likes of ATBCX
.
这将触发像ATBCX这样的人。