Forgive me for the lack of excel termonology I know, I just use the program

I have had much success with Conditional Formatting when it involves
numbers, formulas, and the like. However the current task leaves me in a
quandry.

I am attempting to yield Green for a "Y" or Yes, Yellow for a Blank or "",
or Red for a "N".

I am not sure if I can just use an IF statement that will yield the
conditional "Cell Fill" though.

Any help on the letter value issue?
--
Generally confused, but serving my Lord wholeheartedly