Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
want to find duplicate Phone numbers when typed in excel 2003
I create a column and when i put a phone number in I want to have it
indivcate if its a duplicate perferrable in red |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
want to find duplicate Phone numbers when typed in excel 2003
Let's assume this is your data:
A1: 12345 A2: 54321 A3: 12345 Which cell(s) should be highlighted? -- Biff Microsoft Excel MVP "trvlpal" wrote in message ... I create a column and when i put a phone number in I want to have it indivcate if its a duplicate perferrable in red |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
want to find duplicate Phone numbers when typed in excel 2003
Using column "A", place this formula in "conditional formatting" in cell
"A1", and format the font to "red". Now highlight cell "A1" and all of the cells you want to perform this function in, and "fill down". =COUNTIF(A:A,A1)1 "trvlpal" wrote in message ... I create a column and when i put a phone number in I want to have it indivcate if its a duplicate perferrable in red |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
want to find duplicate Phone numbers when typed in excel 2003
Right click sheet tabview codeinsert thischange column ltr to suit and
color index to suit. Private Sub Worksheet_Change _ (ByVal Target As Range) If Intersect(Target, Columns("M")) _ Is Nothing Then Exit Sub If Application.CountIf(Columns("m"), _ Target) 1 Then MsgBox "Duplicate" Target.Interior.ColorIndex = 6 End If End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "trvlpal" wrote in message ... I create a column and when i put a phone number in I want to have it indivcate if its a duplicate perferrable in red |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
want to find duplicate Phone numbers when typed in excel 2003
Select the whole column (say it's col A), use Format/Conditional Formatting,
change "Cell Value Is" to "Formula Is", enter this formula: =COUNTIF($A$1:$A$1000,A1)1 click Format, then Patterns tab, then select the red font. HTH Bob Umlas Excel MVP "trvlpal" wrote in message ... I create a column and when i put a phone number in I want to have it indivcate if its a duplicate perferrable in red |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Decimal Numbers typed into Excel 2003 read as whole numbers | Excel Discussion (Misc queries) | |||
How do you remove duplicate phone numbers in an Excel spreadsheet | Excel Discussion (Misc queries) | |||
using vlookup to find phone numbers online | Excel Discussion (Misc queries) | |||
Find duplicate records in Excel 2003 | Excel Discussion (Misc queries) | |||
How do you find duplicate values in excel- 2 columns of numbers | Excel Discussion (Misc queries) |