Closed Thread
Results 1 to 2 of 2

If B6 = "NO" input "COMPLETE REASON" in B7, then if C7 has text make B7 blank

Hybrid View

  1. #1
    Registered User
    Join Date
    11-29-2022
    Location
    auckland
    MS-Off Ver
    Microsoft 365 - version 2210
    Posts
    13

    If B6 = "NO" input "COMPLETE REASON" in B7, then if C7 has text make B7 blank

    Good day.

    Please help me if you can.

    I have a problem,

    I have a table - columns A/B/C - Column B will have YES, NO or N/A - If NO then the row below must automatically get text "Complete Reason" - if reason is typed in in Column C then the "Complete Reason" must disappear.

    That is the first part. Once that is done, I need a conditional formatting or setting that if the person did not select YES, NO or N/A then they cannot proceed completing any of the further YES/NO/N/A - This way trying to force them to complete the form properly.

    Column B currently has Data validation list to select the YES/NO/N/A

    If anybody can help me please. I have atttached a file and hope you can see it.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,047

    Re: If B6 = "NO" input "COMPLETE REASON" in B7, then if C7 has text make B7 blank

    Administrative Note:

    Welcome to the forum.

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #5 about thread duplication.

    I am closing this thread, but you may continue here in the original thread: link to be added here

    https://www.excelforum.com/excel-for...-b7-blank.html
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. If B6 = "NO" input "COMPLETE REASON" in B7, then if C7 has text make B7 blank
    By AdrianaBotha2 in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 08-15-2023, 01:15 AM
  2. Requiring input by user to be either "Economy", "Business" or "Club"
    By cmurda in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-08-2014, 08:57 PM
  3. Replies: 1
    Last Post: 08-15-2014, 06:00 AM
  4. [SOLVED] Code that copies row of data to another sheet based on text "Complete"/"Delete"
    By Dremzy in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 04-20-2014, 05:51 PM
  5. Replies: 2
    Last Post: 04-20-2014, 11:18 AM
  6. Replies: 3
    Last Post: 02-16-2011, 02:55 PM
  7. If changed array formula reduce ""\""\""\ - signs to #Missing, will it make ...
    By Maria J-son in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-05-2006, 08:25 AM

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