Conditional Formatting Formula

[easybpw]

Hello everyone,

Thanks in advance for the help. I'm trying to do conditional formatting using a formula with a vlookup and OR statement. However I can't figure it out. My preference is to use wild cards but I understand conditional formatting doesn't allow for this. Below is what I have but it clearly isn't working. I can get it to work if I only have one condition but not if I have more than one. Any help is appreciated.

=VLOOKUP($T2,PAY!$A$4:$E$35,5,0)=(OR("H","E"))

 

[Fluff]

Try

=OR(VLOOKUP($T2,PAY!$A$4:$E$35,5,0)="H",VLOOKUP($T2,PAY!$A$4:$E$35,5,0)="E")

 

[Fluff]

Another possibility

=ISNUMBER(SEARCH(VLOOKUP($T2,PAY!$A$4:$E$35,5,0),"HE"))