hi can someone tell me how to highlight the names that appear in a column more than twice......i have a list of names is c, i would like to highlight any names that appear more than twice
hi can someone tell me how to highlight the names that appear in a column more than twice......i have a list of names is c, i would like to highlight any names that appear more than twice
Use Conditional formatting for that. Assuming the column is A
1) Highlight column A
2) Open the Conditional Formatting > New Rule > Use a Formula
3) Apply this formula:
=COUNTIF(A:A, A1)>2
4) Click on Format and set your formatting goals
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
If this was your data:
Data Range
C 2 Name1 3 Name1 4 Name1 5 Name2 6 Name4 7 Name4 8 Name5 9 Name5 10 Name5
Which cells would be highlighted?
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
DIDNT WORK its in column c so i changed the letter to c but no joy
column c has heading called name in row 1 then after that it a list of names
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks