Conditional Formatting issue

[Jeffrey Green]

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

 

[Fluff]

Maybe something like
=isnumber(match(AC52330,G$2:G$52229,0))

 

[Jeffrey Green]

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]

In that case just use =AC1<>G1