Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
name cross out
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
name cross out
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! -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "John" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cross reference | Excel Discussion (Misc queries) | |||
Cross reference | Excel Discussion (Misc queries) | |||
Cross Referencing | Excel Discussion (Misc queries) | |||
cross referencing | Excel Worksheet Functions | |||
X=y will not cross 0,0 why | Charts and Charting in Excel |