Condit. formatting & adding/deleting rows

[Iceberg]

Good morning,

I have a spreadsheet with a column of numbers in Column S. Column R asks whether or not these numbers should be excluded from the total, and each cell in Column R has a drop-down with Yes/No as the options. If Yes is chosen, the corresponding cell in Column S appears with strikethrough formatting.

So, I've got conditional formatting on each cell in Column S, as per the following:

Formula Is =$R$4="Yes"

And the result is the strikethrough formatting on S4 if "Yes" is chosen in R4.

My problem is that adding or deleting rows plays havoc with the conditional formatting. Is there a way to resolve this or a better alternative altogether?

Thanks!