Conditional Formating Questions

[tobor]

Can anyone tell me how to make cell A1 change color based on the answer in cell C1? For example if cell C1 is "Yes" I would like the font in A1 and C1 to turn blue.

Thank you in advance!

 

[VoG]

Try like this: select columns A and C and apply the CF formula shown

Excel Workbook
	A	B	C
1	A1		Yes
2	A2		No
Sheet4

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1	1. / Formula is =$C1="Yes"	Abc
C1	1. / Formula is =$C1="Yes"	Abc

 

[T. Valko]

Can anyone tell me how to make cell A1 change color based on the answer in cell C1? For example if cell C1 is "Yes" I would like the font in A1 and C1 to turn blue.

Thank you in advance!

What version of Excel are you using?

 

[tobor]

I am using Excel 2007

 

[T. Valko]

I am using Excel 2007

Try this...

• Select cells A1 and C1
• Goto the Home tab>Styles>Conditional Formatting>Manage rules>New rule>
• Use a formula to determine which cells to format
• Enter this formula in the box below:
• =$C$1="yes"
• Click the Format button
• Select the Font tab
• From the Color drop down select a shade of BLUE
• OK out

 

[tobor]

Biff,

Thank you if you are still out there. My question is not how do I apply that to a range of cells. I tried =$A$1:$A$15="Yes" but it only works in A1. Any insight as to what I'm doing wrong?

Thanks in advance

 

[VoG]

Select cells A1:A15 and C1:C15 then use the CF formula

=$C$1="yes"