Please help for macro in Excel "2003"

[vijay]

Hi,

I am working in a organisation and do work in Excel(2003). I work on hug
numbers of invoicing files, were i come across with duplicate file which i
have worked on. but in some case i really don't come to know about the
duplicate files on which i have worked on.
My file are some what like this "SRORNDR_KRODYC_12_012345" and each file is
different from each other.But sometimes i received the same file twice or
thrice, or even more than that.
What i want is whenever i key a file in Column "I" and if the same file is
repeated again at any given row in Column "I", it should show the
repeated/duplicate file in "Blue" color.
I want an Macro on this. which will help me to find the duplicate files
everyday.
It would be helpful if you would write a MACRO on this. As i really don't
know anything about Macro.

--
vijay

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...20e6e99&dg=microsoft.public.excel.programming

 

[Mike H]

Hi,

Microsoft have already provided for this.

Select column I and then
Format|Conditional Format
Formula is
enter the formla
=COUNTIF(I:I,I1)>1
Pick the colour blue and click OK

Duplicates in Column I will now be coloured blue

Mike

 

[vijay]

Thanks,
Mike
But its not working can u please give me Macros on it.

 

[Mike H]

Hi,

Writing a macro to emulate an inbuilt function doesn't seem a good use of
time to me. In what way isn't it working? Try some simple. enter a 1 (one) in
i1 and onother 1 in I2 if they both turn blue then your data are the problem.

Mike

 

[vijay]

Mike,

I did it the same way as you said, but still its not coming up as BLUE color
or Duplicat, i have tried the same formula earlier also, thats the reason i
was asking for MACRO. Is there any other way that it can be worked out.
Please help on this.