In my spreadsheet, I have some columns where the cell values are either Yes or No. When I enter No, I enter it as a Bold Red font.

Is there any way to do this automatically so I don't have to always change the font style and color each time I enter a new "No" value? Like with a dropdown list or with auto-filtering?