+ Reply to Thread
Results 1 to 2 of 2

Preventing value change in Cells based on criteria on another cell

  1. #1
    Forum Contributor
    Join Date
    11-10-2019
    Location
    India
    MS-Off Ver
    2010
    Posts
    143

    Preventing value change in Cells based on criteria on another cell

    Hi,

    Ref to attached sheet, I just need help in following

    If Transaction mode selected is "UPI" or "Wallet" then
    1. Select Bank should change to -- Select --- in the combo box and user should not be able to change anything in C4, C5 and C6 till such time option other than "UPI" or "Wallet" is selected.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    09-30-2019
    Location
    Chiangmai, Thailand
    MS-Off Ver
    Office 2016
    Posts
    568

    Re: Preventing value change in Cells based on criteria on another cell

    Please note, the limitation is must enter data in an order from C2, C3, C4 and C6.
    If user enter in other order (or reverse) it can not control the data (VBA should be use in this case)

    Change data validation of C4 to
    =IF(OR(C3="UPI",C3="Wallet"),C4,ROI!$A$2:$A$14)

    and C6 to
    =IF(OR(C3="UPI",C3="Wallet"),C6,Tenure!$A$1:$A$5)

    Then set protect worksheet.
    ** Need to keep form unchanged or to be original value before use for next clients.

    Regards.
    My English is very poor, so please be patient >_<"

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 8
    Last Post: 07-26-2017, 07:53 PM
  2. [SOLVED] Preventing Cell Change in a Table
    By mtma in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-04-2014, 05:54 PM
  3. Delete and shift cells up based on worksheet change and other criteria
    By beat in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-25-2012, 05:22 PM
  4. change cell values based on criteria
    By ccsmith in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-26-2011, 09:51 AM
  5. [SOLVED] Change text based on other cell criteria?
    By ansoriano1 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-22-2006, 07:05 PM
  6. [SOLVED] Preventing Blank based on another Cell
    By bluegrassstateworker in forum Excel General
    Replies: 1
    Last Post: 08-09-2006, 12:49 PM
  7. [SOLVED] Based on one cell criteria to change the rest of that row to a col
    By Rochelle B in forum Excel General
    Replies: 7
    Last Post: 11-12-2005, 10:50 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1