Change in cell value from another cell

  • Hi all i have two cells A1 & B1. In A1 i have a drop down of (V0,V1,V2) and in B1 i have a drop down of (Pending, Delivered). Now what i want is Whenever i make change in A1 i,e is V1 from V0 , in B1 it should auto change to Pending and if someone changes that pending to delivered. Again in A1 if it is changed to V2 B1 should change back to Pending.
    Please help

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!