i'm not even sure if you can do this, but i'm new to excel so it's possible this is really easier than I am making it.

In A1, if the Answer is "yes" - jump to cell C1.
In A1, if the answer is "NO" - jump to cell D1.

If that is not possible, is it possible to do this -

In A1, if answer is "Yes" - highlight cell c1
in a1, if answer is "No" - highlight cell d1.

BEST CASE ANSWER - COMBINE BOTH !!!!!

thanks for help!