(Solved) – VBA for finding the three first letter in a cell and then color another cell if it is a match

  • by

I have a Excel sheet with different Postal Codes, in coloumn J, like T4N 4L2, H4R 2A5, T6E 6E9.
I would like to run a macro and look for the postal codes that starts T4N* or H4R* and if it is a match in column J, then I would like to color the cell column O and so on. (the customer name is in O)

I have maybe 20 different postal codes, but I looking of ONLY 5 of them and would like to mark the cell in column O with a color if it is a match in column J.

Leave a Reply

Your email address will not be published. Required fields are marked *