选中相应的单元格,然后查看条件格式。 =A4<>INDIRECT(ADDRESS(ROW(),COLUMN(),,,"sheet4")) 转载于:https://www.cnblogs.com/maxthon/archive/2009/03/30/1425291.html