当上面的单元格具有相同的值时，单元格的条件格式 [英] Conditional formatting for cells when cell above has the same value

问题描述

是否有可能将条件格式应用于整个工作表，以便每当上方单元格与当前单元格具有相同的值（文本或数字）时，当前单元格就会格式为黄色填充/蓝色字体？

Is it possible to apply conditional formatting to a whole sheet such that whenever the cell above the current cell has the same value (either text or number) as the current cell, the current cell will be formatted yellow fill/blue font?

例如，当单元格：

A1是 blank

A2 AAA

A3 AAA

A4 AAA

A5是空白

A6 AAA

A7 AAA

只有单元格A3，A4和A7会用黄色填充和蓝色字体格式化。

only cells A3, A4 and A7 will be formatted with yellow fill and font blue.

推荐答案

在A2中，请尝试

=AND(A1=A2,A2<>"")  

，适用于 = $ 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.

这篇关于当上面的单元格具有相同的值时，单元格的条件格式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！