No code required.

Select cells C15 to N15
click Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format
enter this formula
=$M15="yes"

select a format, for example green fill and close all dialogs
keep the cells selected and enter another rule with the formula
=$M15="no"

select a format, for example a red fill and close all dialogs.
You can now copy the cells and use Paste special > Formats to copy the conditional formatting to other rows.