Hello,

I am trying to figure out the formula to highlight building numbers (column B) that are duplicates only if they can be found in more than one region (column A).
The asterisk indicates the cells that should be highlighted:

Region Building Number
Fire TX2291*
Fire FX45
Fire FX45
Fire fg*
Truck fg*
Truck TX2291*
Truck TX2291*
Basketball hi
Basketball hi
Kite fg*
Kite TX2291*
Kite ih
Kite ih

Thank you very much.
Dustin