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
Sheet1, it should be updated in
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.