name cross out

  • Thread starter Thread starter John
  • Start date Start date
J

John

I have a list of names in one work sheet. In another work sheet I have a
vlookup to enter the names. I was wondering if there is something that I
could do that would either cross off the name on the first worksheet
(strikethrough) or something that would help me know which names have been
used.

I am a beginner in excel, so if you have easy instructions it would help out.

Thanks in advance.
 
Let's assume "other sheet" has the names being entered in column B. On this
sheet, select column B, then goto Insert - Name - Define. Type a name (such
as "MyRange"), click 'add', then hit Ok.

Now, back on the first worksheet, select one of the cells with a name (I'll
assume A2). Goto Format - Conditional Format. Change first box to 'formula
is'. Input the following:
=ISNUMBER(MATCH(A2,MyRange,0))
Click the format button, and under the Font tab, select the strikethrough
option. Hit 'ok'. Hit 'ok' again to complete the conditional format. Now,
just copy the formatting to the other cells in your list, and you should be
good to go!
 
Back
Top