3 option result

Hi, be gentle please, I am not good with Formulas or Conditional Formatting and mixing the two together.   I want a cell to show YES or No or CHECK , dependant on the adjacent cell result in a Risk...