Highlight every other row

[LuckyJim1001]

Hi all

I have code that changes every other row, no problem.

Question is what do you all do to run it.

At moment I have it in the Sheet activate event. It scours the rows and changes the highlight of every other row so it is more readable.

Trouble is for more than 5000 rows it slows down the app a bit and does not look very professional.

I thought about a global variable that holds the last row, I could see if the last row has been incremented and only call the highlight procedure if it has been incremented but that just does not feel elegant.

Any ideas ?

Cheers all

[shg]

See http://www.cpearson.com/excel/banding.aspx

[Paul]

Hi LuckyJim,

A quick way, which doesn't involve macros or any manual work (and will auto-update when you delete/add rows) is to use Conditional Formatting. (I'm trying to recall the menu steps from memory, as I don't have 2003 any longer)

For example:

1. Select your entire sheet (click the square to the left of column header A, above row header 1)
2. Click Format -> Conditional Formatting
3. Select 'Formula Is...'
4. In the textbox provided, put the formula: =MOD(ROW(),2)=1
5. Click the Format button and set your Fill color
6. Click OK twice and every other row should now be shaded that fill color.

Hope that helps!