stanleytheyak
Board Regular
- Joined
- Oct 10, 2008
- Messages
- 124
I have a sheet that is similar to the following:
<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!
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!