Use Excel conditional formatting and functions to achieve alternate colors

When browsing the data in a long Excel table, it is possible to see the wrong row, if you can fill a color, you can avoid this phenomenon. With Excel conditional formatting and functions, you can easily achieve the effect of alternating colors. Methods are as follows

Open the Excel file, select the area you want to view, and perform the format → conditional formatting command. Click the Drop-down button below the condition 1 (1) box in the Pop-up Conditional Formatting dialog box, select the Formula option in the Drop-down list that pops up, and enter the formula in the box on the right (ROW (), =mod, 2) =0 ". Then click the Format button, in the Format Cells dialog box that pops up, select the Pattern option, and then select any color under the color (C) tab of the cell shading area, such as red, and click OK to achieve the effect of alternating colors in an Excel table.