In my example the headers are in G10 (Dept) and H10 (Class)
In 2007
Select g11
Cond formatting - manage rules - new rule - use formula to determine . . -
enter following in rule description
=ISNUMBER(SEARCH("P",H11))+G11=5
Format as required - fill cell blue or whatever
Ok
Obviously you will need to change the object cells to suit and use format
painter to rest of range.

Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"Pam" wrote:

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


.