coloring even row without looping

[ericlch16]

Hi

I have a lot of worksheet of many workbooks to colour the alternate row. Currently I am doing a loop for each row of each worksheet of each workbook to change the interior colour of odd numbered rows that contains values. It is working well.

However, when i inserted colour change code, this is slowing down the macro a lot. Is there a better way to do the color without looping and affecting performance of the macro?

Thanks,

 

[JamesCanale]

Use conditional formatting.

MrExcelPlayground.xlsm
	A	B	C
1	Emp Name	Emp ID	Group
2	Emp1	a1	TET
3	Emp2	a2	TET
4	Emp3	a3	BSD
5	Emp4	a4	GERT
6	Emp5	a5	KPIOT
7	Emp6	a6	TET
8	Emp7	a7	BSD
9	Emp8	a8	GERT
10	Emp9	a9	TET
11	Emp10	a10	BSD
12	Emp11	a11	TET
13	Emp12	a12	BSD
14	Emp13	a13	GERT
15	Emp14	a14	KPIOT
16	Emp15	a15	TET
17	Emp16	a16	BSD
18	Emp17	a17	GERT
19	Emp18	a18	KPIOT
20	Emp19	a19	TET
21	Emp20	a20	BSD
22	Emp21	a21	TET
23	Emp22	a22	BSD
24	Emp23	a23	GERT
25	Emp24	a24	KPIOT
Sheet38

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:C25	Expression	=ISODD(ROW())	text	NO

 

[Fluff]

I think you have 3 options
1) use Conditional formatting
2) convert all the data to Tables & use a suitable table style
3) loop through the data with a macro.