Conditional formatting by merged cells

[Imh0tep]

Hello,

I have set conditional formatting in specific range. If is not empty then background color = green + outer borders.

I sometimes use merged cells in this range and by merged cells is the borders unfortunately not complet.

Is there any way how to solve it?

thank you very much

Miroslav

 

[jasonb75]

No, it's an index position. You can have multiple rules for the same range with conditional formatting, the (1) is saying that this is to work with the first condition for the range.