• Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us
Excel

Restricting Input Based on Adjacent Cell’s Specific Text in Excel

0 Comments

Restricting Input Based on Adjacent Cell’s Specific Text in Excel. In this tutorial, we will learn how to restrict input in a cell based on the content of an adjacent cell in Excel using Data Validation. Let’s get started.

Restricting Input Based on Adjacent Cell’s Specific Text in Excel

  • Generic Custom Formula for Data Validation: We will use the following formula in Data Validation’s custom option (not in a cell):
    Restricting Input Based on Adjacent Cell's Specific Text in Excel

    Restricting Input Based on Adjacent Cell’s Specific Text in Excel

=adjacent_cell=“specific_text”

  • adjacent_cell: Refers to the cell you want to check for the specified text. In this example, we assume it’s the left adjacent cell of the entry cell.
  • specific_text: The text you want to check. It can be a hard-coded text or a cell reference containing the text.
  • Excel Example: Allowing Input in Column B Only if Column A Contains Specific Text Imagine an Excel table where you ask a question at the top, and users respond with “Y” in column A if they have the answer, and “N” if they don’t. If they select “Y,” they can write their answer in column B; otherwise, input in column B should be restricted.
    Restricting Input Based on Adjacent Cell's Specific Text in Excel

    Restricting Input Based on Adjacent Cell’s Specific Text in Excel

Here’s how you can achieve this using data validation:

  • Select the range in column B where you want the data validation to apply.
  • Go to “Data” –> “Data Validation.”
  • Choose “Custom” from the drop-down menu for validation criteria.
  • Enter the following formula in the formula box:

=$A3=“Y”

  • Uncheck the “Ignore blank” option.
  • Click “OK” to apply the validation.

Now, if you try to input anything in column B without having “Y” in the adjacent cell (column A), Excel will reject the input. Even if column A is blank, column B will not accept input until “Y” is entered in column A.

Note: Data validation has its limitations. If you copy content from another cell into a validated cell, it will overwrite the validation and stop working. To protect the Excel sheet from users altering the validations, consider using sheet protection.

By following these steps, you can effectively restrict users from entering data in a cell based on the presence of specific text in another cell.

 

Rate this post
39
257 Views
The Double Negatives (--) in ExcelPrevThe Double Negatives (--) in ExcelJuly 22, 2023
50+ Common Excel Keyboard Shortcuts for Accountants to RememberJuly 24, 202350+ Common Excel Keyboard Shortcuts for Accountants to RememberNext

Leave a Reply Cancel reply

You must be logged in to post a comment.

Buy Windows 11 Professional MS Products CD Key
Buy Office 2021 Professional Plus Key Global For 5 PC
Top rated products
  • AVG Internet Security 2021 10 Devices 2 Years Global AVG Internet Security 2021 10 Devices 2 Years Global
    Rated 5.00 out of 5
    $42.20
  • Trend Micro Maximum Security 3 Devices 1 Year key Global Trend Micro Maximum Security 3 Devices 1 Year key Global
    Rated 5.00 out of 5
    $15.00
  • Windows 11 Home Key Global 2021 Windows 11 Home Key Global 2021
    Rated 5.00 out of 5
    $6.00
  • Windows Server 2022 Remote Desktop Services User Connections (50) Cal Key Global Windows Server 2022 Remote Desktop Services User Connections (50) Cal Key Global
    Rated 5.00 out of 5
    $22.00
  • AVG Ultimate 2021 with Antivirus + Cleaner, Secure VPN 10 Devices 2 Years AVG Ultimate 2021 with Antivirus + Cleaner, Secure VPN 10 Devices 2 Years
    Rated 5.00 out of 5
    $47.00
Products
  • Kaspersky Standard - 1 Device, 1 Year (Global License) Kaspersky Standard - 1 Device, 1 Year (Global License) $21.00
  • Office 2024 Home And Business For Mac/Pc Bind Office 2024 Home And Business For Mac/Pc Bind $99.00
  • Windows 10 Home OEM Key Global Windows 10 Home OEM Key Global
    Rated 4.80 out of 5
    $6.00
  • Microsoft Project 2019 Professional Key Global Microsoft Project 2019 Professional - 5 PC
    Rated 4.97 out of 5
    $12.00
  • Project Professional 2010 Microsoft Project Professional 2010 - 1PC $9.00
  • Microsoft Office Home And Business 2016 For Mac Key Global Bind Microsoft Account Microsoft Office Home And Business 2016 For Mac Key Global Bind Microsoft Account
    Rated 4.92 out of 5
    $15.00
  • Microsoft Visual Studio Enterprise 2022 For 1 PC Microsoft Visual Studio Enterprise 2022 For 1 PC $19.00
  • Windows Server 2022 Standard Key Global Windows Server 2022 Standard Key Global
    Rated 4.10 out of 5
    $7.00
  • Windows Server 2022 Datacenter Key Global Windows Server 2022 Datacenter Key Global
    Rated 5.00 out of 5
    $7.00
  • Windows 10 Enterprise LTSC 2019 Key Global Windows 10 Enterprise LTSC 2019 Key Global
    Rated 4.83 out of 5
    $9.00
Product categories
  • Anti Virus
  • Microsoft Office
  • Microsoft Project
  • Microsoft Visio
  • Microsoft Visual
  • Microsoft Windows
  • Other Software
  • Uncategorized

Buffcom.net always brings the best digital products and services to you. Specializing in Office Software and online marketing services

BIG SALE 50% IN MAY

Microsoft Office
Microsoft Windows
Anti-Virus
Contact Us

Visit Us:

125 Division St, New York, NY 10002, USA

Mail Us:

buffcom.net@gmail.com

TERMS & CONDITIONS | PAYMENT GUIDE  | SHIPPING POLICY  | REFUND POLICY

Copyright © 2019 buffcom.net  All Rights Reserved.