Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    May 2002
    Location
    US
    Posts
    439
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Conditional formatting Question (2003)

    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

  2. #2
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional formatting Question (2003)

    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

  3. #3
    4 Star Lounger
    Join Date
    May 2002
    Location
    US
    Posts
    439
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional formatting Question (2003)

    Thanks!

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



    Thanks much!

    Brad

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •