How do I alternate between two colors?

[Andries]

Hi

How do I Alternate between two colors ...(lets say grey and white) I have a list of 700 names and depending of what the total is added next to these names the macro would duplicate each name and paste it onto a new sheet. I want to know if there is a way to then color the back ground off the range of cells that are the same and then change to another color when there is another set of names and so on

thx

Dries

 

[GlennUK]

Look at the conditional formatting mentioned in this thread:

http://www.mrexcel.com/forum/showthread.php?t=541007&highlight=conditional

 

[Peter_SSs]

Another way is to use a helper column. The disadvantage here is it does take another column, but the advantage is the CF formulas are simple (and the helper column can be hidden)

Formula in B2 copied down.
B2:Bxx selected then the Conditional Formatting shown is applied.

Excel Workbook
	A	B
1	Name
2	Name 1	1
3	Name 1	1
4	Name 1	1
5	Name 1	1
6	Name 2	0
7	Name 3	1
8	Name 3	1
9	Name 3	1
10	Name 4	0
11	Name 4	0
12	Name 4	0
13
CF in groups

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2	1. / Formula is =NOT(B2)	Abc
A2	2. / Formula is =B2	Abc