How to format the whole row if some merged (2-line) cell is selected

[el.alex78]

Hello Friends,

I have a question I haven't found any answers properly to fit my request. I tried some Condition Format rules without success.

I would like to format the whole row depending on the selected value (but this value is inside a 2-line Merged cell), see example attached. So when I select "ADD" the second line should change the pattern and if I select "DELETE" the first line should change the pattern.

Could you help me? Thanks

[AliGW]

Welcome to the forum.

The answer is simple: do NOT use merged cells. If you do, you are storing up trouble for yourself (this is just the tip of the iceberg).

[el.alex78]

Thanks Ali, but in this case the Merge is necessary and I'd seen a similar spreadsheet with the same solution, but I could not see how it was made (maybe using VBA). I will keep waiting for another solution. Cheers!!

[FDibbins]

Merge is almost never necessary.

However, this is still doable. You will need 2 rules for each row - 1 for the top row that tests eg A2 for DELETED and formats accordingly, and another rule for the 2nd row that tests A2 for ADD and then formats accordingly

(As Ali said, using merged cells just creates headaches and more work for yourself)

[AliGW]

I would love to know whey you think the merged cells here are necessary. I presume you really mean desirable? I can't see from the screenshot provided why you actually NEED them.