highlighting duplicates

http://www.cpearson.com/excel/duplicat.htm

Will be a ready resource.

--
Regards,
Tom Ogilvy


"Lynn" <moley_cruz@yahoo.com.au> wrote in message
news:1129034579.447163.132050@f14g2000cwb.googlegroups.com...
> thanks Tom,
> but still i need to remmember this formula =Countif($A:$A,A1)>1
> anyway for me to store it in excel and use it ?
>

sorry what do you mean?
do you mean that storing Countif($A:$A,A1)>1 readily for use is not
possible?

I guess that would depend on what you mean by storing.

--
Regards,
Tom Ogilvy


"Lynn" <moley_cruz@yahoo.com.au> wrote in message
news:1129035697.474077.115690@z14g2000cwz.googlegroups.com...
> sorry what do you mean?
> do you mean that storing Countif($A:$A,A1)>1 readily for use is not
> possible?
>

storing like i am able to click on a button and the formula will
perform the job.
can this be done in this case?

Sure. Turn on the macro recorder while you perform the action manually.
then turn off the macro recorder. Now place a button on the sheet and use
the recorded code as the action performed by the button.

I have provided some links to primer material on macros in answer to a
previous post of yours.

--
Regards,
Tom Ogilvy


"Lynn" <moley_cruz@yahoo.com.au> wrote in message
news:1129036867.013902.172180@g49g2000cwa.googlegroups.com...
> storing like i am able to click on a button and the formula will
> perform the job.
> can this be done in this case?
>