Morning everyone
I've linked two sheets capturing the information I'm wanting, but I also want the linked sheet to show the exact colour of the text and background colour of the cell. Is this possible?
In sheet 1, I have the table with contents and have higlighted the cell background red, in B2, B4 and D3.
On the linked sheet tab again with a table of contents, but I'm only capturing the dates from sheet 1.
I would like the linked sheet to also show the red highlighted cells from sheet 1 as red higlighted cells in the linked cell, if the background or text colour has changed ( i've highlighted peach to show you what I mean )
Bookmarks