| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup based on Format
You need a macro to do this!
Where are highlighted cells? In a certain column? Anywhere on the sheet? List them ... Where? Print? In another worksheet? Regards, Stefi €˛Gareth - Network analyst.€¯ ezt Ć*rta: Hey Guys and Girls... I have a Question Is it possiable to do a Vlookup based on the Format of a cell. this is why i have worksheet 1 it has 1000+ names on and there are sevral highlighted names in several colors, what i want is to have Vlookups on worksheet 2 that will find all the names with Blue highlight and list them. can you do this??? and how would you.. Thanks in advance for assist. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert a month to a quarter ...... | New Users to Excel | |||
| format decimals displayed based on results | Excel Discussion (Misc queries) | |||
| change format of cells (bold, italic) based on one cell's answer | Excel Discussion (Misc queries) | |||
| Import Format Using Vlookup | Excel Worksheet Functions | |||
| formula based on format | Excel Discussion (Misc queries) | |||
Linear Mode
