Practical Excel skills [condition formats]

 

I. Chess and board background

1. Format> condition format;
2. Select the formula and enter = Mod (row () + column (), 2)
3. Click the format button to set the cell format.

The formula in the condition format is used to determine whether the remainder of the sum of the row number and column number divided by 2 is 0. If it is not 0, it indicates that the number of rows is different from that of the column number, and the filled cell has a color, otherwise, the color will not be filled. In fact, the formula can also be written as follows: = Mod (row () + column (), 2) <> 0. Therefore, you can add another format to set the color, formula: = Mod (row () + column (), 2) = 0

II,