You can use Conditional Formatting to set the cell font or fill color.
Use the Formula option and this formula: =A1="Yes"

To lock the cell, use Data Validation, custom option and this formula:
=A1<>"Yes"