Results 1 to 16 of 16

If one cell contains #, & other cell is blank, show message & require blank be resolved

Threaded View

jonvanwyk If one cell contains #, &... 06-19-2012, 09:45 AM
tkowal Re: If one cell contains a... 06-19-2012, 10:17 AM
jonvanwyk Re: If one cell contains a... 06-19-2012, 10:22 AM
jonvanwyk Re: If one cell contains #, &... 06-19-2012, 10:56 AM
tkowal Re: If one cell contains #, &... 06-19-2012, 11:17 AM
tkowal Re: If one cell contains #, &... 06-19-2012, 11:25 AM
jonvanwyk Re: If one cell contains #, &... 06-19-2012, 11:27 AM
tkowal Re: If one cell contains #, &... 06-19-2012, 11:45 AM
jonvanwyk Re: If one cell contains #, &... 06-19-2012, 01:36 PM
jonvanwyk Re: If one cell contains #, &... 06-19-2012, 01:41 PM
tkowal Re: If one cell contains #, &... 06-19-2012, 01:46 PM
jonvanwyk Re: If one cell contains #, &... 06-19-2012, 02:07 PM
tkowal Re: If one cell contains #, &... 06-19-2012, 02:08 PM
jonvanwyk Re: If one cell contains #, &... 06-19-2012, 02:19 PM
jonvanwyk Re: If one cell contains #, &... 06-19-2012, 02:16 PM
tkowal Re: If one cell contains #, &... 06-19-2012, 02:23 PM
  1. #1
    Forum Contributor jonvanwyk's Avatar
    Join Date
    06-28-2010
    Location
    Iowa, USA
    MS-Off Ver
    Excel 2010
    Posts
    452

    If one cell contains #, & other cell is blank, show message & require blank be resolved

    Thank you in advance to any help that comes my way. I am trying to figure out how to make the following happen:

    If B5:B6 contains numbers, and C5 is blank, then show messagebox that says "You must select a code for your time."
    If B7:B8 contains numbers, and C7 is blank, then show messagebox that says "You must select a code for your time."
    If B9:B10 contains numbers, and C9 is blank, then show messagebox that says "You must select a code for your time."
    If B11:B12 contains numbers, and C11 is blank, then show messagebox that says "You must select a code for your time."
    If B13:B14 contains numbers, and C13 is blank, then show messagebox that says "You must select a code for your time."

    If C5:C13 contains any information, and B16 is blank, then show messagebox that says "You have coded a day with no scheduled hours. Please enter the number of hours you were scheduled for the day you have coded."
    Last edited by jonvanwyk; 06-19-2012 at 03:05 PM. Reason: clarity

Thread Information

Users Browsing this Thread

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

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