I've been trying to create a vba macros that finds duplicates in Column A but then checks to see if there is a certain value in Column B. (For ex: If a duplicate is found check to see if the cell next to it equals 202112. If a match is found then highlight both of them in yellow but if the cell does not match then don't highlight)

If match:

Please make sure your cells have no highlight before you run, since the script will only change format of cells that do meet conditions. Or you can prepare a script to clear existing highlight (if any) of your data range. Just to prevent mess up of highlight (before - after).