问题描述
我使用条件格式 = ISEVEN(SUMPRODUCT(1 / COUNTIF(A $ 1:A1,A $ 1:A1)))
来自
截屏2:
我需要什么进行更改,使其适用于整张纸,并且每一行都是完全黄色,而不仅是在列A
内?
您需要更改的只是:
-
选择整张纸
-
基于公式并使用条件格式设置规则并使用:
= ISEVEN(SUMPRODUCT(1 / COUNTIF($ A $ 1:$ A1,$ A $ 1:$ A1))))
区别在于绝对列引用与相对列引用。
I use the conditional formatting =ISEVEN(SUMPRODUCT(1/COUNTIF(A$1:A1,A$1:A1)))
from this question which works perfectly.
However, it somehow only applies to Column A
although I tried to run it over the entire sheet.
The setup currently looks like this:
(Sorry for only having it available in German)
Screenshot 1:
Screenshot 2:
What do I need to change so it applies to the entire sheet and each row is completely coloured yellow and not only within Column A
?
All you need to change is:
Select whole sheet
Apply conditional formatting rules based on formula and use:
=ISEVEN(SUMPRODUCT(1/COUNTIF($A$1:$A1,$A$1:$A1)))
The difference is found in absolute vs. relative column references.
这篇关于将条件格式应用于整个工作表(不仅适用于一列)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!