Conditional Format With Wildcard

  • Thread starter Thread starter Pam
  • Start date Start date
P

Pam

Hi,

I have a spreadsheet with Department Column and Class Column. I need to
highlight the department cell when it is a 5 and three-digit class code ends
in anything other than "P". Can this be done in code? I know I can't use
wildcards for "**P" in conditional formatting.

I would appreciate any help.
Thanks,
Pam
 
Russell,

I need to search the three digit code for anything ending other than "P". I
tried your solution to see if I could make it work and then try to modify as
needed, but could not get it to work.

Thanks,
Pam
 
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
 
Russell,

Here's what I need to happen:
ColB ColC
Dept Class
5 GRR Highlight
5 GRP
3 GRR
5 GRU Highlight
1 GRU

If Dept 5 has code ending in anything other than "P" - highlight it.

Thanks again for your help.
Pam
 
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,

I changed the semi-colon to a comma and it works. Can you tell me what the
"1" is for in (H11,1)?

Thank you.
Pam
 
Ah, sorry for the mistake, using swiss german excel and we use ";"
instead of ","

Right( text, number_of_characters )
text is the string that you wish to extract from.
Click to expand...
number_of_characters indicates the number of characters that you wish to extract starting from the right-most character.
Click to expand...

and Russells formula would work as well, just add wildcards:
=ISNUMBER(SEARCH("??P",H11))+G11=5
 
Hubisan,

I'm sorry, I should have known that. Thank you for the formula and info you
supplied. One more thing, can this be written so that I can use it in vba
code?

Thanks again,
Pam
 
Back
Top