+ Reply to Thread
Results 1 to 8 of 8

How to check adjacent cell for value and display error message for certain conditions

Hybrid View

  1. 05-01-2017, 07:09 PM #1
    Trebor76
    Trebor76 is offline
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,565

    Re: How to check adjacent cell for value and display error message for certain conditions

    If a user enters a value of "L" or "OL" into the sheet, it should check the cell immediately to the left
    Hi ScotyB,

    If we're in cell A4 you can't check to the immediate left so what's the rule there?

    Robert
    ____________________________________________
    Please ensure you mark your thread as Solved once it is. Click here to see how
    If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
    Reply With QuoteRegister To Reply
  2. 05-01-2017, 07:30 PM #2
    ScotyB
    ScotyB is offline
    Forum Contributor
    Join Date
    08-04-2010
    Location
    Adelaide, Australia
    MS-Off Ver
    Office 365
    Posts
    176

    Re: How to check adjacent cell for value and display error message for certain conditions

    Lol, my bad, Trebor - it should have been B4 - I've just finished a night shift and was tired...

    Good pickup - ta

    AJ
    Always grateful for the help here - thanks.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Display error message if cell has no value
    By callum91 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-20-2015, 10:40 AM
  2. Display ActiveCell and Adjacent Cell Values in message Box
    By Tellm in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-27-2015, 12:16 PM
  3. Check [This Cell] Against [That List] And Display [Corresponding Adjacent Value]
    By Sandcastle in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-19-2014, 06:07 PM
  4. Muliple Conditions to Check in a table to display value in a cell
    By Kapil Gosain in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-10-2013, 03:36 AM
  5. VBA - Check 3 rows if blank and display text in one of them in adjacent cell
    By guitalex in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-17-2012, 09:32 AM
  6. Excel 2007 : Check two cells, display error message if one blank
    By Ron1121 in forum Excel General
    Replies: 2
    Last Post: 12-18-2009, 05:20 PM
  7. [SOLVED] How to display a blank cell with no error message
    By Juco in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 01-31-2005, 05:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1