So I have this spreadsheed with two areas (D7:AD16 and D18:AD27). Now I want to format the colors in D18:AD27 such that yellow color is added to every cell that is empty in D18:AD27 but not in D7:AD16.
I use the following custom formula that is applied to one row like this:
the conditional format tab:
And it produces the desired result for that row:
when I try to do this for 2 dimensions I change the formula to
and apply it to the area like this:
Which I thought would work, however, this removes all the yellow color-formatting from the area so how can I achieve the desired result without doing this for every row manually?