View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gareth - Network analyst. Gareth - Network analyst. is offline
external usenet poster
 
Posts: 21
Default Vlookup based on Format

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.