Excel formatting operations

1. How to color alternate row automatically in excel:

There are several ways to do this formatting but I am sharing one with using mod function.

1. Firstly select the rows you want to be shaded.

2. Now go to Home > conditional formatting > New rule

3. Now in select new rule section, select “use a formula to determine which cell to format”

4. In the format values where this formula is true, enter =mod(row(),2)=0

5. Select the color of your choice and click on OK

.

2. How to color duplicates values or rows in excel:

1. Select the rows within you want to check the duplicate value

2. Go to Home > conditional formatting > Highlight cell rules > Select duplicate values

Select the color of your choice and click on OK

All duplicate records are now highlighted.

3. how to Color specific Cell with specific color

1. Select the table or range where you want to change the background color of cells.
2. Navigate to the Home tab, Styles group, and choose Conditional Formatting > highlight cell rule> text that contain
3. Enter the text which to be highlighted

4. Enter another text that need to be highlighted > select another color > Click OK