Question about Conditional Formating

[tazmtiger]

I have a worksheet where the answer in column "G" is yes or no,

I want the text in column "A" to turn green if the answer in "G" is yes and red if the answer in "G" is no.

My working range is A8:A40 & G8:G40

Anyone can assist me in getting this done?

Thank you!

 

[T. Valko]

I have a worksheet where the answer in column "G" is yes or no,

I want the text in column "A" to turn green if the answer in "G" is yes and red if the answer in "G" is no.

My working range is A8:A40 & G8:G40

Anyone can assist me in getting this done?

Thank you!

What version of Excel are you using?

 

[tazmtiger]

excel 2003

 

[kpark91]

1) Select A8:A40
2) Conditional formatting -> Formula
3) Type in

=$G8="yes"

4) Set filling to green


5) Select A8:A40
6) Conditional formatting -> Formula
7) Type in

=$G8="no"

8) Set filling to red


The exact match is important (capitalization) so change "yes" or "no" to the desired text.
Selecting only A8:A40 is important because the rules will only appy there.

 

[T. Valko]

excel 2003

Try this...

Select the *entire* range A8:A40 starting from cell A8. Cell A8 will be the active cell. The active cell is the one cell in the selected range that is not shaded. The formula will be relative to the active cell.

• Goto the menu Format>Conditional Formatting
• Condition 1
• Select the Formula Is option
• Enter this formula in the box on the right:
• =G8="Yes"
• Click the Format button
• Select the Font tab
• Select a shade of green
• OK
• Click the ADD button
• Condition 2
• Select the Formula Is option
• Enter this formula in the box on the right:
• =G8="No"
• Click the Format button
• Select the Font tab
• Select a shade of red
• OK out