How to Highlight Rows Using Multiple Colors

Step 1: Select the range, Click on “Formatting Menu” and Select New Rule

Select the range of data which you want to highlight using three colors and click on “Conditional Formatting” and then select the “New rule” option.

Step 2: Specify the formula

To highlight the rows using three colors you need to enter the formula three times which will be like this: “=MOD(ROW(),3)=1”, “=MOD(ROW(),3)=2”, “=MOD(ROW(),3)=0”.

Step 3: Specify Formatting and Click “OK”

Select the desired color to be filled from the “Fill” tab and click “OK”.

Step 4: Result

You can apply color to the rows by selecting the rows individually.

Microsoft Excel is a spreadsheet editor offered by the Microsoft 365 Suite which allows users to create, and edit their sheets with the help of the exciting features offered by MS Excel. While creating or editing a sheet providing a concise view of your sheet is a good way to gain attention from others and adding color to the alternate rows is a good way to make your sheet attractive. Coloring the rows in the sheets makes your data easier to read. In this article, we will explore how to apply color to alternate rows in MS Excel.