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?
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?