I am trying to copy the cell value along with the format from a reference
cell. The cell being referenced has a formula for the value and conditional
formating to define the color.

A simple reference i.e. ='sheet1'!H3 will only copy the value.

How can I copy the formating?

i.e. the H3 cell in sheet1 has fill color = red. I want the reference cell
to be red too.