如何基于另一个表的Excel中使用条件格式
我试图基于该单元格中的任何文本字符串，特别是我输入了另一表。可以根据项目的基础从辅助表中添加或从辅助表中添加或减去的文本字符串。我尝试了几种不同的方法，但无济于事。任何帮助将不胜感激。我知道我可以为每个文本字符串输入另一个条件，但是认为这是一个更好的选择，因为我的文本字符串可以定期更改。我正在尝试使用不同的列和不同的参考表来执行此操作，但是如果我能找到一种使它与之合作的方法，我认为它将与所有人一起使用。并非所有人都将是绝对的匹配，我也希望能够在单元格内部搜索包含的文本字符串，而不仅仅是我想要的文本字符串。 我的文件
I am trying to highlight cells in column G based off of whether or not the cell contains any of the text strings I have entered into another table, specifically the Pgroup table in Column U. I would like this to become a flexible conditional format based on text strings that can be added to or subtracted from the secondary table based on a project basis. I have tried a couple different ways but to no avail. Any help would be appreciated. I know I can enter another condition for every text string but thought this would be a better alternative since my text strings can change regularly. I am trying to do this with different columns and different reference tables as well but if I can find a way to make it work with one I think it will work with all. Not all will be absolute matches, I'd also like to be able to search for text strings inside of a cell that contains more than just the text string I'm looking for.
My File
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
条件格式 - ＆GT;新规则 - ＆gt;公式 - ＆gt;
= sum（countif（$ a2，$ p $ 2：$ p $ 7））其中a2是格式的列的开始，而p2：p7是您的值所在的位置。
要格式化整个行，请将“应用于”到$ 2：$ nofyourtable
Conditional formatting --> New Rule --> Formula -->
=SUM(COUNTIF($A2,$P$2:$P$7))Where A2 is the start of a column to format and P2:P7 is where your values are located.
To format the whole row, set "Applies to" to $A$2:$endOfYourTable