macos 当单元格具有特定单词时突出显示 excel mac 2011 中的行
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/10947147/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Highlight the row in excel mac 2011 when a cell has a specific word
提问by No Importa
In Excel 2011 Mac (it seems to be important since other referenced solutions in stackoverflow for excel windows or mac older versions don't seem to work).
在 Excel 2011 Mac 中（这似乎很重要，因为 stackoverflow 中用于 excel windows 或 mac 旧版本的其他参考解决方案似乎不起作用）。
I want to apply conditional formatting so when a cell in column D includes a word "student" the full row which includes the cell gets a color format (blue color for the text white/empty filling for the cell).
我想应用条件格式，因此当 D 列中的单元格包含“学生”一词时，包含该单元格的整行将获得一种颜色格式（文本为蓝色，单元格为白色/空填充）。
I have tried INDIRECT and some other formulas but I don't get it right. Only the cell that includes the word gets the formatting, not the whole row (that is, the rest of the cells on the same row where the pattern matches).
我试过 INDIRECT 和其他一些公式，但我不明白。只有包含单词的单元格获得格式，而不是整行（即，模式匹配的同一行上的其余单元格）。
回答by Iakovosian
Admittedly, this answer is based on the Windows version but it should still work for you.
(Pictures taken from mix of Windows and Mac versions where possible.)
诚然，此答案基于 Windows 版本，但它仍然适用于您。
（图片取自 Windows 和 Mac 版本的混合版本。）
Select Manage Rules...from the Conditional Formattingmenu.
Click the New Rule...button.
Select Use a formula to determine which cells to format, enter the formula as shown below, and then click the Format...button to choose your conditional format (blue text with no fill).
- You said you were looking for the word "student" in column D, and I have assumed that row 3 is the first row that you want this conditional formatting to be applied. Just change the 3to another row number if this is not the case.If the word "student" is not the only thing in your target cell, then use the following formula instead:
=ISNUMBER(SEARCH("student",$D3))Then type a range into the Applies totextbox as shown.
- In this example, we assume that row 3 is the first row and row 400 is the last row that you want the conditional formatting to be applied to.
- Note that we did not include column letters in the formula since we want every column of each row to be included.Click OKand you should be done.
从条件格式菜单中选择管理规则...。
单击新建规则...按钮。
选择使用公式来确定要设置格式的单元格，输入如下所示的公式，然后单击格式...按钮选择您的条件格式（没有填充的蓝色文本）。
- 您说您要在 D 列中查找“学生”一词，并且我假设第 3 行是您希望应用此条件格式的第一行。如果不是这种情况，只需将3更改为另一个行号。如果目标单元格中不只有“学生”一词，请改用以下公式：
=ISNUMBER(SEARCH("student",$D3))然后在“适用于”文本框中键入一个范围，如图所示。
- 在此示例中，我们假设第 3 行是第一行，第 400 行是您希望应用条件格式的最后一行。
- 请注意，我们没有在公式中包含列字母，因为我们希望包含每一行的每一列。单击“确定”，您应该就完成了。
I hope this works for you.
我希望这对你有用。
回答by Billy N.
Follow these steps for conditional formatting.
请按照以下步骤进行条件格式设置。
Step 1 - Select Conditional Formatting> New Rule...
步骤 1 - 选择条件格式>新规则...
Step 2 - Select StyleDropdown
第 2 步 - 选择样式下拉菜单
Step 3 - Choose Classic
第 3 步 - 选择经典
Step 4- Select Dropdown with Format only top or bottom ranked values
第 4 步- 选择下拉列表，仅设置排名靠前或靠后的值
Step 5 - Select from Dropdown Use a formula to determine which cells to format
第 5 步 - 从下拉列表中选择使用公式确定要设置格式的单元格
Step 6- Highlight desired Cells and take note of the current cell. (D3)
第 6 步- 突出显示所需的单元格并记下当前单元格。(D3)
Step 7 - Use formula: =MATCH("Student",D3,0)in the formula section.
Again, D3 is the current cell.
第 7 步 -在公式部分使用公式：=MATCH("Student",D3,0)。
同样，D3 是当前单元格。
Step 8 - Press OK
步骤 8 - 按确定
