Conditional Formatting and IF

[djl0525]

On row 6, I enter a bunch of letters. I need C6 to change color with conditional formatting if two conditions are met.

C6 contains a T
and E6:G6 contain an A

Can somebody help me get started with this, please?

Thanks -- DJ

 

[T. Valko]

On row 6, I enter a bunch of letters. I need C6 to change color with conditional formatting if two conditions are met.

C6 contains a T
and E6:G6 contain an A

Can somebody help me get started with this, please?

Thanks -- DJ

Ok, does that mean EVERY cell in E6:G6 has to contain an "A"?

What version of Excel are you using?

 

[country101]

You will use the AND function in your conditional formatting. I dont know exactly what you are wanting it to do, but you would make the and statement have at least two arguements that are true. Such as a cell(a6) has a 6 in it and your statements could be AND(A6>1,A6<200). Both statements are true, so whatever format you select would work.

 

[djl0525]

Thank you both.

I'm using Excel 2007 and I want the T in column C to stand out if any cell from E6:G6 contains the single letter A.

DJ

 

[T. Valko]

Thank you both.

I'm using Excel 2007 and I want the T in column C to stand out if any cell from E6:G6 contains the single letter A.

DJ

Try this...

Select cell C6

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:

=AND(C6="T",OR(E6:G6="A"))

Click the Format button
Select the desired style(s)
OK out

 

[country101]

Once I get to a computer that isnt using this stupid 2010 version of excel, I will see about working out a formula for you. I cant figure out how to do anything with this newer version.

To clarify, you want c6 to have some kind of formatting if any of e6:g6 contain an A regardless of what the other cells have? IE e6=5 f6=A g6=asdfgasdg would mean that c6 would get formatted and the same if any or all of them had an A

 

[djl0525]

Thank you country101 and T. Valko.

I used =AND(C6="T",OR(E6:G6="A")). It does exactly what I need.

Thanks again!
--DJ

 

[T. Valko]

Thank you country101 and T. Valko.

I used =AND(C6="T",OR(E6:G6="A")). It does exactly what I need.

Thanks again!
--DJ

You're welcome. Thanks for the feedback!