Format all cells in a row where data in column c equals NO

=$C1="No"

and apply the formatting required to all the cells in the column and all the cells in the rows underneath

If you want the formatting to apply as new rows are added then either copy the formatting from one of the cells, or make your data into a Table, then new data that is added on the next available row under the table will acquire the formatting