Conditional formatting Question (2003)

Topic

New Reply

Greetings!

I have a file that contains a bunch of data. In Column ‘C’ I have data that is mixed. meaning some cells are all numeric and some are alpha-numeric.

EX:
12345678
PP12345679

Using conditional Formatting, how do I highlight the cells that contain the “PP” items? I looked for a “contains” but did not see that.

Thanks,
Brad

Reply | Quote

Replies

If the PP is always in the first two positions, you could use the formula
=left(A1,2)=”PP”

if the”PP” is anywhere within the cell you can use the formula:
=SEARCH(“PP”,A1)>0

Substitute the correct cell reference for the A1 in my examples

Reply | Quote

Thanks!

and yes, the “PP” is always in the first 2 positions.

Thanks much!

Brad

Reply | Quote