Thank you Mancubus
--------------------------------
2nd and 3rd not clear to me.
since they are about formatting, record a macro while manually formatting the cells in Columns A and B of sheet List2. then post your recorded macro here so we can insert/adopt it to below code.
_________________________

Here is a YouTube link that basically explains what I'm doing