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:
=AND(ISBLANK(D23:AD23);NOT(ISBLANK(D12:AD12)))
the conditional format tab:
And it produces the desired result for that row:
Problem
when I try to do this for 2 dimensions I change the formula to
=AND(ISBLANK(D18:AD27);NOT(ISBLANK(D7:AD16)))
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?