sradkovich
New Member
- Joined
- Aug 30, 2012
- Messages
- 15
I am trying to establish a formula (im thinking its best fit is in conditional formatting) that will cause Excel to higlight the values which occur most often within a column (or better yet -variable colors from red to yellow red being the most often and yellow being the least often).
So for example:
Row ___________
1 | Alan |
2 | Alan |
3 | Alan |
4 | Alan |
5 | Alan |
6 | Bob |
7 | Bob |
8 | Bob |
9 | Craig |
10 | Craig |
Since "Alan" occurs 5 times, it would hilight Alan in red,
Bob (3 times) - Orange
Craig (twice) - Yellow
This would also update as i add to the rows, so if, overtime, i add Craig 5 more times in rows 11-15 - Craig would end up being Red.
Thanks in advance.
So for example:
Row ___________
1 | Alan |
2 | Alan |
3 | Alan |
4 | Alan |
5 | Alan |
6 | Bob |
7 | Bob |
8 | Bob |
9 | Craig |
10 | Craig |
Since "Alan" occurs 5 times, it would hilight Alan in red,
Bob (3 times) - Orange
Craig (twice) - Yellow
This would also update as i add to the rows, so if, overtime, i add Craig 5 more times in rows 11-15 - Craig would end up being Red.
Thanks in advance.