Conditional formatting: OR statement

[Finney1]

Hello,

How do I conditionally format a cell to change if any letters other than "A" or "V" are entered?

Thank you!

 

[Jonmo1]

Welcome to the board..

You probably actually want AND instead of or..

And does it have to be letters? or basically ANYTHING other than A or V?
What about Blanks?

Try this for starters

=AND(A1<>"A",A1<>"V",A1<>"")

This is TRUE if A1 = ANYTHING other than A or V or Blank.

Hope that helps.

 

[Finney1]

Welcome to the board..

You probably actually want AND instead of or..

And does it have to be letters? or basically ANYTHING other than A or V?
What about Blanks?

Try this for starters

=AND(A1<>"A",A1<>"V",A1<>"")

This is TRUE if A1 = ANYTHING other than A or V or Blank.

Hope that helps.

Hi-

Thanks for responding so quickly. The cell should have either an "A" or "V" entered. Nothing else will be correct. I want the cell to turn black if it is blank or if another letter/character is entered. Does that change your formula?

Thank you!

 

[Jonmo1]

OK, so to make it work for blanks as well
=AND(A1<>"A",A1<>"V")

This will make the formatting apply if ANYTHING other than "A" or "V" is entered in A1.
Actually, it will also accept "a" or "v" ...it's not case sensitive.

If you need it to be case sensitive

=AND(NOT(EXACT(A1,"A")),NOT(EXACT(A1,"V")))

 

[Finney1]

OK, so to make it work for blanks as well
=AND(A1<>"A",A1<>"V")

This will make the formatting apply if ANYTHING other than "A" or "V" is entered in A1.
Actually, it will also accept "a" or "v" ...it's not case sensitive.

If you need it to be case sensitive

=AND(NOT(EXACT(A1,"A")),NOT(EXACT(A1,"V")))

jonmo1 -

It works like a charm! Thank you so much for your quick service AND accurate formula!! You made my day.



finney1

 

[Jonmo1]

Glad to help, thanks for the feedback.