Try this for the conditional formatting

=OR(A2="",A2="Yes")

and in C2 enter

=IF(A2="No","You must complete the required information","")

Note. I've assume A2 only allows Yes or No answers via data validation

VBA Noob