Greetings, I would like to use conditional formatting to highlight an entire row if the data in column C equals "No". I am continually adding new rows and columns so I would like this formatting to apply as I add more rows and columns.

Thank you!