Solved Conditional formatting using wildcards

October 14, 2016 at 13:30:18
Specs: Windows 7
Hello community, need some help with a conditional formatting formula. I need to apply 2 formulas to the same column:
1st one is to check if $P7="Purchase" and $AH7 does not contain the text string Pre-Approval
2nd one is to check if $P7="Purchase" and $AH7 does contain the text string Pre-Approval

I will apply different formatting to each.

Part of the problem is that the text string Pre-Approval sometimes has a space before and/or after the word.

Here is what I have tried but no luck:
=AND($P7="Purchase",$AH7<>"*Pre-Approval*")
and
=AND($P7="Purchase",$AH7="*Pre-Approval*")


See More: Conditional formatting using wildcards

Reply ↓  Report •


#1
October 14, 2016 at 19:05:22
✔ Best Answer
You don't need a Wildcard, try using TRIM() function, something like:

=AND(TRIM($P7)="Purchase",TRIM($AH7)<>"Pre-Approval")

MIKE

http://www.skeptic.com/


Reply ↓  Report •
Related Solutions


Ask Question