Need help with a spreadsheet

[wycherley]

Hello

Can someone tell me the best way to set up a spread sheet. that will log peoples names and an activity that they have chosen for an after school club. But i need there to be a coloum that automaticaly brings up names that apear more than once.

Thankyou

[Bob Phillips]

I would use conditional formatting. I have created an example and uploaded
it to http://cjoint.com/?bAkX4b3i5Q for you to check-out.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"wycherley" <[email protected]> wrote
in message news:[email protected]...
>
> Hello
>
> Can someone tell me the best way to set up a spread sheet. that will
> log peoples names and an activity that they have chosen for an after
> school club. But i need there to be a coloum that automaticaly brings
> up names that apear more than once.
>
> Thankyou
>
>
> --
> wycherley
> ------------------------------------------------------------------------
> wycherley's Profile:
http://www.excelforum.com/member.php...o&userid=30857
> View this thread: http://www.excelforum.com/showthread...hreadid=505249
>

[wycherley]

that is what i want the highlighting is a good idea, but i need the name's to automatically be highlighted as i wont be the one operating the spreadsheet.

[Bob Phillips]

It is automatic, add a name that is already there, and you will see that.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"wycherley" <[email protected]> wrote
in message news:[email protected]...
>
> that is what i want but i need the name's to automatically be
> highlighted as i wont be the one operating the spreadsheet.
>
>
> --
> wycherley
> ------------------------------------------------------------------------
> wycherley's Profile:
http://www.excelforum.com/member.php...o&userid=30857
> View this thread: http://www.excelforum.com/showthread...hreadid=505249
>

[David McRitchie]

I can't see the spreadsheet but when you create the conditional
formatting you normally select entire columns so that when you
get a match those cells on a row are highlighted. The formulas
are based on the active cell.
http://www.mvps.org/dmcritchie/excel/condfmt.htm

So if the names are not being highlighted they were not included
in the selection. The formulas should have the active cell with
$ with the column because each cell on the row will be checking
that same column.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"wycherley" <[email protected]> wrote in message
news:[email protected]...
>
> that is what i want but i need the name's to automatically be
> highlighted as i wont be the one operating the spreadsheet.
>
>
> --
> wycherley
> ------------------------------------------------------------------------
> wycherley's Profile: http://www.excelforum.com/member.php...o&userid=30857
> View this thread: http://www.excelforum.com/showthread...hreadid=505249
>