Conditional formatting using Or formula

[Alpacino]

Hi peeps,

Just a quick one how do I write a formula in conditional formatting using OR.
I would like the cell interior to be Green if value = H or = AH or = PH

Thanks

 

[VoG]

Try like this

=OR(A1="H",A1="AH",A1="PH")

 

[mikerickson]

You could conditionaly format A1 with a formula like
=OR(A1="H",A1="AH",A1="PH")
or
=ISNUMBER(MATCH(A1, {"H","AH","PH"}, 0))

 

[Alpacino]

Can I copy this format to all cells in sheet???

 

[VoG]

Select all the cells, then set the CF using the top left cell in your selection in the CF formula (i.e. if necessary change A1).

 

[Alpacino]

Thank you

 

[T. Valko]

=ISNUMBER(MATCH(A1, {"H","AH","PH"}, 0))

Can't use array constants in refedits.

 

[mikerickson]

Can't use array constants in refedits.

I missed that.
One would either have to define a Name
Name: listOfStrings RefersTo: ={"H","AH","PH"}

and the CF formula =ISNUMBER(MATCH(A1, listOfStrings, 0))

or put the list of highlighted strings in a range and refer to that.