Hi,

Hoping someone can help. I have a list of Patient ID's in Column A.
Sometimes the ID will appear once, maybe twice, sometimes as much as 5 or 6
times. An example:

COLUMN A
101
102
102
102
103
103
104
105
105

What I want Excel to do is automatically shade the entire row every time the
number changes in this list. For example, make all the 101 records RED, the
102 records green, the 103's yellow, the 104's blue, etc. etc. I'm familiar
with conditional formatting, but am not sure it this would be the way to go.

Can anyone help?

Thanks! Joe