将条件格式应用于整个工作表（不仅适用于一列） [英] Apply conditional formatting to entire sheet (not only to one column)

问题描述

我使用条件格式 = 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.

这篇关于将条件格式应用于整个工作表（不仅适用于一列）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！