1. Select the range/column

2. From menu FormatConditional Formatting

3. For Condition1Select 'Cell valu is' and enter
="Y"
Click Format ButtonPattern and select your color (say Green)

4. Click on Add button.

5. For Condition2Select 'Cell valu is' and enter
=""
Click Format ButtonPattern and select your color (say Yellow)

6. Click on Add button.

7. For Condition1Select 'Cell valu is' and enter
="N"
Click Format ButtonPattern and select your color (say Red)

8. Hit OK

If this post helps click Yes
---------------
Jacob Skaria


"RMartin" wrote:

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