Conditional formatting issue

Options

Conditional formatting to change background color of a row is defaulting back to white if a particular column is updated. Is there a way to make sure column changes do not impact the row format?

Answers