Forum Discussion
Multiple search and conditional formatting
Important: make sure your sample file only contains made up addresses and no names of people.
Hi
Thanks for the message.
While I was waiting for a reply, I ended up doing a Find for all postcodes that were within the numbers I needed and then highlighted them in yellow. Then I Chose to Hide all the rows that had no fill. It was a long way of doing it as there are 83 post codes that I needed to filter for Invalid/out of area post codes.
I have attached some screen shots. Unfortunately, the address column has the street number and name in it and cannot be separated otherwise it would be a sinch! I have replaced the street name and number with "123 None Street" so you can see the formatting etc...
Thanks for your help, I really appreciate it
- Looks as if the post codes are always the last four characters in the cell? Anyway, if you ask an Excel question, why not attach an Excel file, not a screen-shot.
- Yes that is right and Because I had to redact a lot of information..... just to get the screenshot while keeping the quality of the data there
If you prefer for a spreadsheet then I can..... this has very limited data and I don't know if it will impact anything...
I didn't realise a screenshot would be an issue.
laurenwhelan Looks like all your addresses have the post code as the last four characters. In that case, there's a relatively simple formula, see attached. I added an extra column on the right-hand side of the table and I converted your post code list to a table as well (tblPostCodes).
