How to highlight every second row?

[sami770]

Hi,
I would like to highlight rows (on selected cells) like a Zebra, so that every other row will get a different background color.
I need a macro solution.

Please see sample attached...

Any idea how to do this?

[Pete_UK]

No need for a macro - use conditional formatting with a formula like this:

=MOD(ROW(),2)=1

for one colour and the other colour set as a standard fill.

Hope this helps.

Pete

[arlu1201]

Do you want any 2 colors or the 2 in the file?

[Pete_UK]

@sami770

I see that you have Excel 2003 in your profile, yet you posted an .xlsx file. Please update your profile if you have a later version of Excel.

Pete

[sami770]

Thanks, you helped me a lot!
Also, I fix my profile ;-)

@sami770

I see that you have Excel 2003 in your profile, yet you posted an .xlsx file. Please update your profile if you have a later version of Excel.

Pete

[sami770]

It's ok now, Pete's solution worked for me
Thanks!

Do you want any 2 colors or the 2 in the file?

[arlu1201]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

[sami770]

OK, done!
Thanks!

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.