Results 1 to 4 of 4

Thread: Conditional Formatting issue
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Oct 2007
    Location
    Detroit area
    Posts
    1,011
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Conditional Formatting issue

    i have a list of 100,000 rows.
    the first 52229 rows or so are fine.

    i pulled in the Tariff code into column AC, starting in row 52330 (everything above is fine, now i want to check tariff numbers)
    i have the Tariff number used in column G.
    So Column G should match the correct Tariff in column AC. (in a perfect world)

    I want to condtionally format AC, so that if AC <> G, then red fill . . .

    having a challenge doing this.

    thoughts??
    thanks

  2. #2
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    28,038
    Post Thanks / Like
    Mentioned
    467 Post(s)
    Tagged
    47 Thread(s)

    Default Re: Conditional Formatting issue

    Maybe something like
    =isnumber(match(AC52330,G$2:G$52229,0))
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  3. #3
    Board Regular
    Join Date
    Oct 2007
    Location
    Detroit area
    Posts
    1,011
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional Formatting issue

    hi, thanks . . . not sure how that would work . . .
    if all rows were bad, let's start at row 1.

    I need AC1 to equal G1
    I need AC2 to equal G2
    etc.

    thanks

  4. #4
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    28,038
    Post Thanks / Like
    Mentioned
    467 Post(s)
    Tagged
    47 Thread(s)

    Default Re: Conditional Formatting issue

    In that case just use =AC1<>G1
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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