Conditional Formatting issue

Jeffrey Green

Well-known Member
Joined
Oct 24, 2007
Messages
1,017
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
 

Some videos you may like

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
42,378
Office Version
365
Platform
Windows
Maybe something like
=isnumber(match(AC52330,G$2:G$52229,0))
 

Jeffrey Green

Well-known Member
Joined
Oct 24, 2007
Messages
1,017
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
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
42,378
Office Version
365
Platform
Windows
In that case just use =AC1<>G1
 

Watch MrExcel Video

Forum statistics

Threads
1,101,851
Messages
5,483,311
Members
407,393
Latest member
GeorgeBrown

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top