I found this link and it works and also keeps your own formatting and conditional formatting active.
I've attached the link and a file with fake data to show you (Fake Data can be generate at will of the Fake Datagenerator site)
https://trumpexcel.com/highlight-act...-column-excel/
Bookmarks