Juggernaut
New Member
- Joined
- May 4, 2002
- Messages
- 6
I've been racking my brains for about an hour trying to write a macro do this, and have failed so far.
I have an excel sheet with many horizontal lines of data.
What I want to do is check all the values in Column A from A3 to A10000.
Where there are 3 values the same (values will be text - a person's name), those cells turn green
Where there are 6 values the same, those cells turn yellow
Where there are 9 values or more the same, those cells turn red.
Any suggestions on the code required to do this?
This message was edited by Juggernaut on 2002-05-05 08:52
I have an excel sheet with many horizontal lines of data.
What I want to do is check all the values in Column A from A3 to A10000.
Where there are 3 values the same (values will be text - a person's name), those cells turn green
Where there are 6 values the same, those cells turn yellow
Where there are 9 values or more the same, those cells turn red.
Any suggestions on the code required to do this?
This message was edited by Juggernaut on 2002-05-05 08:52