Conditional formatting - multiple text condition

[Peterso]

If I want to set when A1="Registered" or A1="Advertised" then change A1 to red in color. How can I set? Thanks!

 

[SanjayGMusafir]

A1="Registered" or A1="Advertised"

Use the following formula for Conditional Format

=OR(A1="Registered",A1="Advertised")

 

[Peterso]

Thanks for you prompt reply. Now my situation changed. The new condition is If A1<>"Registered" or A1<>"Advertised" then A1 change to red. In another word, there is no color only if A1="Registered" or "Advertised"

 

[SanjayGMusafir]

A1<>"Registered" or A1<>"Advertised"

Check this and revert - to turn red

=OR(A1<>"Registered",A1<>"Advertised")

 

[Peterso]

It doens't work since according to the logic, if A1="Registered" then A1 is not "Advertised" then it turn red

 

[Fluff]

How about

=and(A1<>{"Registered","Advertised"})

 

[Peterso]

How about

=and(A1<>{"Registered","Advertised"})

It doesn't work. kind of syntex error

 

[Fluff]

Oops, forgot you can't use that format for CF, try

=and(A1<>"Registered",A1<>"Advertised")

 

[Peterso]

It works. Thanks

 

[Fluff]

Glad we could help & thanks for the feedback.