View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CJ CJ is offline
external usenet poster
 
Posts: 102
Default Advanced Filter by Cell Formatting

Hi groupies

Is it possible to use an Advanced Filter to filter cells by their formatting.

For example. If I have a list of customers, some from the States some from
Canada and some from Europe, I would like to be able to filter by the format
of the data in the PostalCode/ZipCode field.

Canadian Postal Codes are L9L 9L9 format, US being 99999-9999 etc.

Any ideas?
--
Thanks for the brainwaves!

CJ
I blame the parents........