Microsoft Excel->如何将颜色应用于交替的行，而不应用于特定的列（通过公式） [英] Microsoft Excel -> How to apply color to alternating rows, but not to a certain column (via a formula)

问题描述

因此说明了

So it is explained here by Microsoft Support how to apply a colour to alternating rows, using a formula:

=MOD(ROW(),2)=0

However, what if we want to, in the formula as well (not via the selection) specify 1 specific column X within the solution to which the colour should not be applied?

解决方案

One option, replacing X with the number of the column: A=1, B=2, and so on...

=AND(MOD(ROW(),2)=0,COLUMN()<>X)

In action:

这篇关于Microsoft Excel->如何将颜色应用于交替的行，而不应用于特定的列（通过公式）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！