Hello,
I have two dynamic tables.
Table 1 gets its values from several other sheets, and is spread to 8 columns, but each column has a separate color that is always constant.
Table 2 gets its values from Table 1, but changes the order in different columns.
I need a formula for the conditional formatting option that says something to the effect of: Find the value of this cell (from table 2) in Table 1, and mimic its color.
Is this possible?
Thanks in advance,
Jona
Bookmarks