Results 1 to 2 of 2

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

Threaded 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.

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. [SOLVED] 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