更新时间:2023-02-04 19:54:34
在A2中,请尝试
=AND(A1=A2,A2<>"")
,适用于 = $ 2:$ 20 或任意降低或能够使用黄色填充和蓝色字体。
= $ 2:$ 20
with Applies to =$2:$20 or as far down as you wish or are able to go, with yellow fill and blue font.
=$2:$20
当上面的单元格具有相同的值时,单元格的条件格式
Excel:如果上面的单元格具有相同的值?