I have two pivot tables. Both have the same size / structure, but they visualize two different aspects.
I can use conditional formatting to change e.g. the background color of the tables cells (e.g. <=0 → gray, >0 → light red).
Now i want to change the formatting of one tables cells by combining the values of both tables, e.g. like this:
table1.cell = (0 or empty) → light red
(table1.cell = (0 or empty) and table2.cell >0) → red
table1.cell >0 → normal
I tried to formulate a formula in the dialog for conditional formatting, but i don’t know how to write the reference so that the formatting applies to all “connected” cells.
With connected cells i mean:
table1.A1 is connected to table2.A1
table1.A2 is connected to table2.A2
…
table1.B1 is connected to table2.B1
table1.B2 is connected to table2.B2