Need help with a spreadsheet

  • Thread starter Thread starter wycherley
  • Start date Start date
W

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
 
that is what i want but i need the name's to automatically be
highlighted as i wont be the one operating the spreadsheet.
 
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)
 
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.
 
Back
Top