Conditional formatting I think?

Hi all

Pretty new to excel really but keen to use it for my job and trying to test out the basics

I have excel with 4 questions, each question has the same 2 answers. Depending on the combination of answers selected will determine the overall answer. How do i get excell to automatically populate the overall answer for me based on the combination of answers? What formulas do i need and for th