Data replication

Hi everyone,
I have two tabs in a spreadsheet. I want to pull data from one column into another column on another tab.

So in the destination tab I'm pressing = then clicking the field with the info I want to replicate.

It replicates the data, but not the formatting. Any idea if I can change that? Or a workaround?

I'm trying to demonstrate if a project is red/amber/green in that field, and have it replicated in a field on another tab. I don't want to have to copy and paste - I want it to do it automatically when the source is updated.


Thankyou in advance!!