Conditional Formatting

[RMartin]

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?

 

[Jacob Skaria]

1. Select the range/column

2. From menu Format>Conditional Formatting>

3. For Condition1>Select 'Cell valu is' and enter
="Y"
Click Format Button>Pattern and select your color (say Green)

4. Click on Add button.

5. For Condition2>Select 'Cell valu is' and enter
=""
Click Format Button>Pattern and select your color (say Yellow)

6. Click on Add button.

7. For Condition1>Select 'Cell valu is' and enter
="N"
Click Format Button>Pattern and select your color (say Red)

8. Hit OK

If this post helps click Yes

 

[T. Valko]

What version of Excel are you using?

 

[RMartin]

Office 2007

 

[RMartin]

Thanks. Didn't even occurr to me to set 3 specific Formats

Question. The Green and the Red work (i.e. Y=Green, N=Red) however the
yellow for the ="" is not coming up. Any ideas?

Yellow is not necessary, just eye candy and eye catching for what
information is not yet entered. I suspect the non-formatted cell is just as
catching.

 

[RMartin]

Scracth that, The first drop down had "Blanks" as an option. I chose that
and it fixed my issue. Thank you for your time.

Ross

 

[Jacob Skaria]

If the cells are genuine blanks; in 2007 from 'New formatting rule' window
....from 'Format only cells with' select 'Blanks' and select yellow color..

If this post helps click Yes

 

[T. Valko]

Ok, I see you have a solution so, carry on!