If Column contins "X" then....

[abarone]

Hi, I am very new to Excel formulas and am trying to do something that I didn't think would be as complicated as its turning out to be.

I'm trying to do a formula that looks for "X" within Colum B
If it finds "X" within that colum, than the text in Cell A988 will be Black
If there is no "X" in the colum, the text in Cell A988 will be White

Any help would be greatly appreciated!

 

[T. Valko]

Hi, I am very new to Excel formulas and am trying to do something that I didn't think would be as complicated as its turning out to be.

I'm trying to do a formula that looks for "X" within Colum B
If it finds "X" within that colum, than the text in Cell A988 will be Black
If there is no "X" in the colum, the text in Cell A988 will be White

Any help would be greatly appreciated!

The default text color is black. Are you using some other color as the default color?

What version of excel are you using?

 

[abarone]

I am using Excel 2007.

I understand the default is Black for the text. I guess than that I want the text in that box to be White if the "X" does not appear in the B Column.

 

[shift-del]

Hi

Use conditional formatting with this formula:

 =COUNTIF(B:B,"X")=0

And set the text color to WHITE.

 

[T. Valko]

I am using Excel 2007.

I understand the default is Black for the text. I guess than that I want the text in that box to be White if the "X" does not appear in the B Column.

Ok, try this...

• Select cell A988
• 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:
• =COUNTIF(B:B,"X")=0
• Click the Format button
• Select the Font tab
• In the Color drop down, select white
• OK out

 

[abarone]

Thanks, but what cell would I put that Formula in?

I want cell A985 to contain the text that will change color.

sorry, I posted this while the last comment was made

 

[T. Valko]

Thanks, but what cell would I put that Formula in?

I want cell A985 to contain the text that will change color.

sorry, I posted this while the last comment was made

You don't put the formula in a cell.

Follow these steps:

• Select cell A985
• 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:
• =COUNTIF(B:B,"X")=0
• Click the Format button
• Select the Font tab
• In the Color drop down, select white
• OK out

 

[abarone]

Thank you!!

 

[T. Valko]

Thank you!!

You're welcome!