Conditional Formatting
 

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

Conditional Formatting
 

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

Conditional Formatting
 

What version of Excel are you using?

--
Biff
Microsoft Excel MVP


"RMartin" wrote in message
...
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

Conditional Formatting
 

Office 2007
--
Generally confused, but serving my Lord wholeheartedly


"T. Valko" wrote:

What version of Excel are you using?

--
Biff
Microsoft Excel MVP


"RMartin" wrote in message
...
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

Conditional Formatting
 

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.
--
Generally confused, but serving my Lord wholeheartedly


"Jacob Skaria" wrote:

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

Conditional Formatting
 

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
--
Generally confused, but serving my Lord wholeheartedly


"Jacob Skaria" wrote:

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

Conditional Formatting
 

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
---------------
Jacob Skaria


"RMartin" wrote:

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.
--
Generally confused, but serving my Lord wholeheartedly


"Jacob Skaria" wrote:

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

Conditional Formatting
 

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

--
Biff
Microsoft Excel MVP


"RMartin" wrote in message
...
Office 2007
--
Generally confused, but serving my Lord wholeheartedly


"T. Valko" wrote:

What version of Excel are you using?

--
Biff
Microsoft Excel MVP


"RMartin" wrote in message
...
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