R
rap43
In a column is there a way to find duplicate values, like the exact same
names ?
names ?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
Shane Devenshire
Hi,
In 2007 - highlight the column and choose Home, Conditional Formatting,
Highlight Cell Rules, Highlight Duplicates
In 2003 - use a formula approach or condtional formatting:
1. Select the cells you want to format
2. Choose Format, Conditional Formatting
3. Choose Formula is from the first drop down
4. In the second box enter the formula:
=COUNTIF(A$1:A$100,A1)>1
5. Click the Format button
6. Choose a color on the Patterns tab (or any available option)
7. Click OK twice.
To make this case sensitive replace the above formula with
=SUMPRODUCT(--EXACT(A$1:A$100,A1))>1
In 2007 - highlight the column and choose Home, Conditional Formatting,
Highlight Cell Rules, Highlight Duplicates
In 2003 - use a formula approach or condtional formatting:
1. Select the cells you want to format
2. Choose Format, Conditional Formatting
3. Choose Formula is from the first drop down
4. In the second box enter the formula:
=COUNTIF(A$1:A$100,A1)>1
5. Click the Format button
6. Choose a color on the Patterns tab (or any available option)
7. Click OK twice.
To make this case sensitive replace the above formula with
=SUMPRODUCT(--EXACT(A$1:A$100,A1))>1
R
rap43
Thanks Shane I had findly found that and it works great.
T
Tony
Shane,
Thank you!! it worked great!!!
Thank you!! it worked great!!!
Shane Devenshire said:Hi,
In 2007 - highlight the column and choose Home, Conditional Formatting,
Highlight Cell Rules, Highlight Duplicates
In 2003 - use a formula approach or condtional formatting:
1. Select the cells you want to format
2. Choose Format, Conditional Formatting
3. Choose Formula is from the first drop down
4. In the second box enter the formula:
=COUNTIF(A$1:A$100,A1)>1
5. Click the Format button
6. Choose a color on the Patterns tab (or any available option)
7. Click OK twice.
To make this case sensitive replace the above formula with
=SUMPRODUCT(--EXACT(A$1:A$100,A1))>1
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire