1、首先要有两张一样的表，如图中的表1、表2
2、选择要匹配的表格——>【开始】——>【条件格式】——>【新建规则】
3、选择【使用公式确定要设置格式的单元格】——>输入公式【=A1='表2'!A1】——>选择【格式】——>选择你喜欢的颜色——>点击两次确定
4、如图所示为表1显示内容，颜色绿色为相同部分，颜色偏粉色的为不同部分
▼ 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