I have this fx in col "G".
=IFERROR(VLOOKUP(E9,'[QtyOnHand'!$A:$B,2,),"0")
It just pulls the on hand inv qty over from another sheet so I can compare it to yesterdays on hand qty I posted in F.
When qty differ between F and G I want to have either F or G change color. I picked red.
Problem is, if I have a 0 in F, the true value in G is #N/A and not 0. therefore I get a lot of "red" popping up. So I'm not getting a true picture.
Is there an easier way to achieve my goal?
=IFERROR(VLOOKUP(E9,'[QtyOnHand'!$A:$B,2,),"0")
It just pulls the on hand inv qty over from another sheet so I can compare it to yesterdays on hand qty I posted in F.
When qty differ between F and G I want to have either F or G change color. I picked red.
Problem is, if I have a 0 in F, the true value in G is #N/A and not 0. therefore I get a lot of "red" popping up. So I'm not getting a true picture.
Is there an easier way to achieve my goal?