1、选中要输入数据的A2:C28单元格区域
2、[开始]选项卡下，依次单击【条件格式】——>【新建规则】——>【使用公式】——>在公式编辑框中输入以下公式：=$A2<>""
3、单击【格式】按钮，在弹出的【设置单元格格式】对话框中切换到【边框】，然后选择一种边框颜色，单击【外边框】按钮
▼ Tags
▼ Archive
- March 2022
- February 2022
- January 2022
- December 2021
- November 2021
- October 2021
- September 2021
- August 2021
- July 2021
- June 2021
- May 2021
- April 2021
- March 2021
- February 2021
- January 2021
- December 2020
- November 2020
- October 2020
- September 2020
- August 2020
- July 2020
- June 2020
- May 2020
- April 2020
- March 2020
- February 2020
- January 2020
- December 2019
- November 2019
- October 2019
- September 2019
- August 2019
- July 2019
- June 2019
- May 2019
- April 2019
- March 2019
- February 2019
- January 2019
- October 2018
- August 2018
- July 2018
- June 2018
- May 2018
- December 2017
- October 2017
- August 2017
- July 2017
- June 2017
- May 2017