Conditional Format If Or function

[The Animal]

Hi
I want to use a IF(OR formula "Use a formula to determine which cells to format" if SM or SMX or D3 is found.
I tried to use the "Specific Text" option using SM,SMX,D3 but removed conditional format if one of those conditions are found
Thanks

 

[dave2018]

=If(OR(A1="SM",A1="SMX",A1="D3"))

replace A1 with your cell in question...

 

[The Animal]

Thanks for your help but keeps telling me a problem with formula?

 

[AhoyNC]

Conditional formatting just needs a TRUE or FALSE.
Drop the IF and try something like
=OR(A1="SM",A1="SMX",A1="D3")

 

[The Animal]

Great thanks so much

 

[AhoyNC]

You're welcome. Thanks for the feedback.

 

[dave2018]

Conditional formatting just needs a TRUE or FALSE.
Drop the IF and try something like
=OR(A1="SM",A1="SMX",A1="D3")

oops! my mistake .
sorry about that.