Hello,
In the same spreadsheet I have two twin data tables. One is for manually entering data, the other one shows the result of the calculation of the manual entry and some other figures.
Now I would like to mark some cell somehow (patterns, font color, bold, etc.) in the first table in a way that the "twin" cell in the second table would change formatting to pair that one - and the other way around would be nice as well.
Table 1-> D5:R23
Table 2-> D28:R46
So for example, D5 and D28 cells should be "twins" in terms of formatting.
Is this easy to do with VBA code?
Thanks!
In the same spreadsheet I have two twin data tables. One is for manually entering data, the other one shows the result of the calculation of the manual entry and some other figures.
Now I would like to mark some cell somehow (patterns, font color, bold, etc.) in the first table in a way that the "twin" cell in the second table would change formatting to pair that one - and the other way around would be nice as well.
Table 1-> D5:R23
Table 2-> D28:R46
So for example, D5 and D28 cells should be "twins" in terms of formatting.
Is this easy to do with VBA code?
Thanks!