If Column contins "X" then....

abarone

New Member
Joined
Mar 8, 2011
Messages
6
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!
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

T. Valko

Well-known Member
Joined
May 9, 2009
Messages
16,623
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

New Member
Joined
Mar 8, 2011
Messages
6
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

Well-known Member
Joined
Aug 28, 2009
Messages
516
Office Version
  1. 365
Platform
  1. Windows
Hi

Use conditional formatting with this formula:
Code:
 =COUNTIF(B:B,"X")=0
And set the text color to WHITE.
 

T. Valko

Well-known Member
Joined
May 9, 2009
Messages
16,623

ADVERTISEMENT

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

New Member
Joined
Mar 8, 2011
Messages
6
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

Well-known Member
Joined
May 9, 2009
Messages
16,623

ADVERTISEMENT

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
 

Forum statistics

Threads
1,141,730
Messages
5,708,143
Members
421,549
Latest member
Dtcfire

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top