Excel实现据条件整行变色.docxVIP

Excel实现根据条件整行变色编写目的:本文档用于讲解如何在Excel表格中通过某项条件突出显示整行内容.并详细描述具体操作步骤以实现效果.操作步骤:打开需要进行操作的Microsoft Office Excel表格文档.找到需要进行操作的数据表.本例中需要将“驻留方式”为驻点的记录整行突出蓝色显示。选择需要进行操作的数据表，除标题部分。点击“开始”中的“条件格式”后，选择“管理规则”。弹出“条件格式规则管理器”窗口，点击“新建规则”按钮。弹出“新建格式规则”窗口，由于我们是对“驻留方式”列进文字判断，所以我们选择“使用公式确定要设置的单元格”。在“编辑规则说明”中“为符合此公式的值设置格式”输入条件。由于“驻留方式”列位于Excel表格F列，而第一行数据位于Excel表格中的3行，所以我们在公式中填入“=$F3=驻点”。(由于对“驻留方式”取值时列不变，所以在F前加“$”用于固定列，而需要根据每行数进行单独判断，所以3前不用加入“$”符号)然后点击“格式”按钮。弹出“设置单元格格式”窗口，由于本例中需要将整行底色变为蓝色，所以选择“填充”选项卡，并将“背景色”修改为“蓝色”，最后点击“确定”按钮。这里可以根据不同需求，修改为其他格式。返回“新建格式规则”窗口后，点击“确定”按钮。返回“条件格式规则管理器”窗口点击“确定按钮”。最后整个表格可以根据条件以不同的底色显示出来。Communist Party Member Zhuang Shaozhen (Nanxun people) that the new Department to send back working the Lake, served as captain of the Countys political team. Party people such as Wang Huapeng, transferred from the administrative team, Zhejiang Province, Wujiang County political team, active in the anti-Japanese activities, political team as smallCommunist Party Member Zhuang Shaozhen (Nanxun people) that the new Department to send back working the Lake, served as captain of the Countys political team. Party people such as Wang Huapeng, transferred from the administrative team, Zhejiang Province, Wujiang County political team, active in the anti-Japanese activities, political team as smallCommunist Party Member Zhuang Shaozhen (Nanxun people) that the new Department to send back working the Lake, served as captain of the Countys political team. Party people such as Wang Huapeng, transferred from the administrative team, Zhejiang Province, Wujiang County political team, active in the anti-Japanese activities, political team as small