工具/原材料
Excel2016版、电脑。
1、打开电脑找到并点击Excel2016版软件;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/f636afc379310a55ec9e66a6b94543a98226102d?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、打开软件以后,在空白表格内先全部选择表格;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/29381f30e924b89928b1c16a60061d950b7bf6d7?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、选中好表格以后,在开始栏的界面中找到并点击“条件格式”下来选项中的“突出显示单元格规则”的命令;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b8014a90f603738dc34ab770bd1bb051f819ec64?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、点击以后,在突出显示单元格规则的下拉选项选择“其它规则”;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/5d6034a85edf8db1c9e1c7360723dd54574e7490?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、点击其它规则以后,在弹出的对话框中选择“使用公式确定要设置格式的单元格”并在下框中输入公式:“=mod(row(),2)”并点击格式按钮;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b812c8fcc3cec3fdd2ba1d27d888d43f869427df?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、点击格式按钮,在弹出的界面中选择“填充”并对填充的颜色进行设置;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a50f4bfbfbedab64551ce892f936afc379311e71?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
7、参数设置并确定好以后,此时表格已按照设置的要求隔行换颜色。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/267f9e2f0708283864fc7946b699a9014d08f1eb?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)