Excel: Clone cells and have the exact same value & formating

Question

Yesterday I tried to make another step with my network table to give an easy view on the current network cabling / patching of our company. I remember that I did something similar in the past but I think it was only the value that was mimiced.

Basically what I would like to do is that if I change the value of
B145 on Sheet1, it should be updated in B20 on Sheet2. Same goes with the formatting. If I change the color from nothing / white to red or dark grey or any other color it should as well change to that formatting.
Sadly I did not find anything useful because it always gives me results for "just enter = in an empty field and select your target cell" or condition formatting.

Edit: As requested by Lee On the left you can see the original table which will be updated whenever there is a change. On the right you can see the cloned table which copies / clones the value but not the coloring.

Basically the S6.3 on the right should be red and if for example the entry on Slot 9 changes to empty or an important value, it should change the color to the same as the parent field.

For security reasons I cannot show more than this. Sorry.

Answer 1

To use same value in different sheet just use formula ie in your case. B20 cell in Sheet 2 would have formula
=Sheet1!$B$145

for formatting it can't be done this way, AFAIK, but what you can do is make conditional formatting from the menu in a particular cell.
There you have options like IF Cell value (=,>,<,'like'..) then use particular formatting to this cell (you can choose any formatting options as you do for any other cell in the spreadsheet).