Your reference in the formula box in the Conditional Format dialog should be
relative for row and absolute for column.
Rgds,
ScottO

"Ted Rogers" wrote in message
...
| Thats an excellent suggestion. The only thing I've noticed is that when I
| try to apply conditional formatting to the whole sheet based on your
| suggestion, only the helper column colours up - is it possible to colour
the
| complete rows of each entry too?
|
| Thank you for your continuing help!
|
| Ted
| "ScottO" wrote in message
| ...
| OK....
| Is there any harm in adding a helper column with serial numbers in it to
| use
| as an alternate member reference number?
| You could keep track of the highest serial number issued by another
spare
| cell - say H1 - with a formula like =Max(A:A).
| Then use the method described in my last post, but based on the serial
| number.
| I know it's getting convoluted, but it's the best my feeble abilities
will
| allow ...
| Rgds,
| ScottO
| "Ted Rogers" wrote in message
| ...
| | Many thanks for that. The problem is that the other person adds a
member
| by
| | name and allocated a membership number which also doubles up as a
login
| to
| | the club's website. This number is the person's surname plus a number
| | (smith123).
| |
| |
| | "ScottO" wrote in
message
| | ...
| | Would this give you what you want ...
| |
| | At the end of the month, your friend has the "official" copy of the
| file.
| | In a spare cell - say G1 - enter the last registered member ref#.
| | I say "enter" so that this is a fixed value, and not a formula like
| | =Max(MemberRefNum) which will increase if more members are added
| during
| | the
| | month.
| | Then apply conditional formatting to highlight all members with ref#

| the
| | entry in G1.
| | That way whenever your friend (or your friend's friend) adds
members,
| they
| | will be formatted with whatever highlight you choose.
| |
| | Rgds,
| | ScottO
| |
| | "Ted Rogers" wrote in message
| | ...
| | | I have been asked to try and solve a problem that a friend has.
| (Please
| | try
| | | and ignore the workflow - I have suggested other ways of doing it
| but
| he
| | | won't have it!). He has a spreadsheet containing around 1500
| entries.
| | These
| | | consist of club members with an exclusive reference number each.
My
| | friend
| | | is responsible for the overall membership but sends a copy of the
| file
| | to
| | | another person who operates within it month to month. At the end
of
| the
| | | period the file is sent back to my friend with new members etc.
and
| my
| | | friend then wants to import it into his file (which he has been
| amending
| | at
| | | the same time)
| | |
| | | What he would like to do is to import this file, avoid
duplications
| and
| | | highlight in some way the new members (by maybe colouring the
lines)
| to
| | | distinguish them from old ones (the entries are sorted by surname
so
| new
| | | entries could appear in the middle of the sheet).
| | |
| | | I hope this is clear, I know he's be better off using Access but
| he's
| | been
| | | using this for years and wants to do it this way. Is it possible
| please?
| | |
| | | Many thanks,
| | |
| | | Ted
| | |
| | |
| |
| |
| |
| |
|
|
|
|