Conditional Formatting between a number and #N/A

[MikeyZ]

I lost my thread on this one. My apologies.

In Col F I have yesterdays Inv qty's.
Values = 0 thru whatever.
In col G I have the latest up to date qty's pulled from a Pivot Table report.

My Vlookup fx pulls the data over into Col "G".

In Col "F" I have a conditional fx so that when the value in F differs from G it turns "red.

Here's my problem.
When the Vlookup can't find a P/N it yields a #N/A tag but I have that shown as a "0"
=IFERROR(VLOOKUP(E636,'LiveQty!$A:$B,2,),"0")
My latest try at the CF criteria are as follows:
=IF(OR(F9="0",G9="0"),FALSE,F9<>G9)

So I may have F = 5500 but G = 0 (because of the error #N/A returned from the VLOOKUP).
As a result cell F doesn't turn color like I hoped.
And what happens when F = 0 and G = 0, F turns color.

What am I doing wrong?

 

[AliGW]

It's here: http://www.mrexcel.com/forum/excel-questions/982860-conditional-formatting-question.html#post4716373