Conditional Format With Wildcard
Hubisan,
This looks like it will work, but it give error message "The formula you
typed contains an error." and highlights "P" in the formula.
Thanks for your help.
Pam
"Hubisan" wrote in message
...
Use this formula as conditional formatting:
=AND(RIGHT(H11,1)<"P";G11=5)
And btw, u can use wildcards whith some formulas like
"=Search("*P",H11)"
Hubisan
|