View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Pam[_3_] Pam[_3_] is offline
external usenet poster
 
Posts: 56
Default 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