Change Fill Color on Row When Name Changes

[stanleytheyak]

I have a sheet that is similar to the following:

	A	B	C
1	Name	Item	Description
2	Tom Smith	1	Item 1
3	John Adams	2	Item 2
4	John Adams	3	Item 3
5	Ronald Regan	4	Item 4
6	Ronald Regan	5	Item 5
7	Ronald Regan	6	Item 6
8	John Kennedy	7	Item 7
9	John Kennedy	8	Item 8
10	John Kennedy	9	Item 9
11	John Kennedy	10	Item 10

<colgroup><col span="2"><col><col></colgroup><tbody>
</tbody>

What I would like to do is to have each name in column A determine fill color for the row. So, Row 2 (Tom Smith) would be green. Rows 3-4 (John Adams) would be light green. Rows 5-7 (Ronald Regan) would be blue. And so on.

I need to automate this, as the list changes frequently. Names are added/removed, items are added, etc.

Any help in doing this would be greatly appreciated!

 

[mumps]

It seems that the color is different for each name. If this is correct, you would need a list of names, perhaps in a separate sheet, along with the corresponding colors for each name. If names are added, you would need to update the names and colors on the separate sheet.