how do i change the color of every other row on excel for mac

How Do I Change The Color Of Every Other Row On Excel Mac Keyboard So

Do you want the coloring to be based on Customer number Or just every time the Customer number is different from the above.

Select Use a formula to determine which cells to format and enter this formula.

I added another column as general and pasted in an extra customer number, which dropped the leading zero, did the formula, then hid the column.

Frankly, I have always found that somewhat annoying and would tend to prefer a VBA solution.

If you have a problem which is similar to this problem but sufficiently different, you could always post another question.

Provide details and share your research But avoid Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

Not the answer youre looking for Browse other questions tagged excel excel-formula or ask your own question.

Instead of right-clicking one cell and choose to insert a new row manually, you can actually batch create new rows alternatively using AutoFill and Go To feature of Excel.

Then put the cursor at the bottom right corner of E3, drag it to select all the cells in column D and column E.

How Do I Change The Color Of Every Other Row On Excel Mac Keyboard So

But note that controlG doesnt exist on a mac keyboard so I used Edit, Find, Go To.

How Do I Change The Color Of Every Other Row On Excel For Mac