Difficulty getting proper "not equal to" Logic into conditional formatting.

[creaseA]

Here is my goal. A cell (say A1) contains different strings, string1, string2, etc...... . A different cell has conditional formatting with the following logic such that, string1 and string2 are important, but all other strings are not.

"If A1 <> "string1" OR A1<> "string2", then grey out the cell...."

Ie if either string1 or string2 is present in A1, the cell should not be greyed out, otherwise the cell should be grey.

I have tried multiple logic statements none of which seem to have worked in the conditional formatting box "if this equation is true, do this"

One thing I tried to use was OR(A1<> "string1", A1 <> "string2") nut this did not work. Additionally, excel seems to add an equal sign and additional "" to strings that I input which I believe means am not inputing this correctly.

Any help or advice on logic would be greatly appreciated. Still relatively new to this type of work.

 

[Fluff]

You need to use and, not or

=AND(A1<>"string1", A1<>"string2")

 

[creaseA]

You need to use and, not or

=AND(A1<>"string1", A1<>"string2")

I thought this as well however when I input =AND(A1 <> "string1", A1<> "string2") into the conditional formatting rule, the cell remains greyed out no matter what string is passed into A1. Here is my actual input: =AND($J$25<>"Double Bevel", $J$25 <>"Double Vee")

 

[Fluff]

Did you select "use a formula" for the rule

 

[creaseA]

Did you select "use a formula" for the rule

Yes I ensured that I used a formula. So currently it should be setup that if that forumla is true it greys out the cell.

Thats why I'm confused that AND does not work since if either string1 or string2 were actually present, the AND would evaluate as False and no formatting would occur......

 

[Fluff]

In that case check that the contents of J25 are exactly the same as the strings, no typos or leading/trailing spaces.

 

[creaseA]

In that case check that the contents of J25 are exactly the same as the strings, no typos or leading/trailing spaces.

This was the issue. I have accidentally typed "string1 " instead of "string1"

 

[Fluff]

Glad it's sorted & thanks for the feedback.