VBA code for last active cell to remove ordering alert?

[kehong216]

Hi

I have this problem where I want to have an ordering alert when the total number of fruit is less than 10. I have done this by using the formula =IF($F$2<10,"Order More","")

However, I want to be able to remove the "Order More" alert when I have received the PO (purchase order) in the last active cell.
Is there a VBA code for this?

I expect in my excel sheet that, the "Order More" sign will disappear when A4 (or the last active cell in column A) has the date of the PO.

Thank you very much!

Cheers

Ken

[nankw83]

How about just changing your formula a bit

Please Login or Register  to view this content.

[kehong216]

Thank you so much for your help! This is brilliant! Appreciate for your time and help!

[nankw83]

Glad to help & thanks for the added Rep.