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"))
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"))