If you place a hyperlink inside an IF statement or a CHOOSE statement, the original formatting of the cell is not changed. When copying, paste the formula.
IF
CHOOSE
=IF(TRUE, HYPERLINK("https://www.stackoverflow.com"))