If Cell is 5 or more less than a cell

[nniedzielski]

I have a macro running and pulling in two values.



Row I and Row J have the two values.


I cases where they do not match, and Row J is more than 5less than Row I, I need to put an “X” in Row L


Thanks,

 

[Fluff]

Ok, try

If Val(PendingQty) < Val(AuthQty) - 5 Then

 

[nniedzielski]

perfect, thank you

 

[Fluff]

You're welcome & thanks for the feedback