I would like to hire an Excel Expert

My sheet is an online nomination process where horse & riders compete at a national show and do their entries online. To avoid them selecting a class and leaving the rider name blank, I need a formula so if YES is selected a certain cell must have an entry