一、开启工作薄的宏控制
![](https://www.kelegu.com/wp-content/uploads/2020/01/image004.png)
![](https://www.kelegu.com/wp-content/uploads/2020/01/image005.png)
二、按ALT+F11,进入VBA编辑页面,双击sheet1,,就是要添加代码的工作表将代发复制进去
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Target.Cells(1).Name = "light"
End Sub
![](https://www.kelegu.com/wp-content/uploads/2020/01/image006.png)
而后确定
三、点击开始,条件格式---管理规则,开始新建两个条件格式
![](https://www.kelegu.com/wp-content/uploads/2020/01/image007.png)
![](https://www.kelegu.com/wp-content/uploads/2020/01/image008.png)
![](https://www.kelegu.com/wp-content/uploads/2020/01/image009.png)
四、编缉规则,设置应用区域
添加选取要应用高亮显示的数据区域,注意,不要全部选定工作表,需要多少选多少,不然会影响运行速度
![](https://www.kelegu.com/wp-content/uploads/2020/01/image010.png)
点击应用,而后确定关闭对话框
五、显示效果如下
![](https://www.kelegu.com/wp-content/uploads/2020/01/image012.png)