更新时间:2023-02-04 19:24:09
使用公式进行条件格式化
Conditional formatting using a formula
=OR(A2=A1,A2=A3)
请注意,如果要始终使用相同的公式,则在列表的顶部需要一个虚拟行,在底部需要一个虚拟行来处理边缘情况.或者,对顶部(=A2=A3
)和底部(=A8=A7
)项目使用不同的公式.
Note that a dummy row is needed at the top of your list and another one at the bottom to deal with the edge cases if you want to use the same formula throughout. Alternatively, use different formulas for the top (=A2=A3
) and bottom (=A8=A7
) items.