+ Reply to Thread
Results 1 to 2 of 2

prevent blank cell in excel worksheet

  1. #1
    jatman
    Guest

    prevent blank cell in excel worksheet

    i have a work book with four tabs. i have figured out how to use the cell
    validation rules, but none of those work for what i need:

    if the cell is blank, i need an error message to appear (like in the cell
    validation part). the cell must start of blank, and the user must enter a
    value equal to or greater than 0. if the user tries to go to another cell,
    they should get the warning messge to enter a vaue equal to or greater than 0.

    any suggestions?

    regards,

    jat

  2. #2
    Registered User
    Join Date
    07-27-2006
    MS-Off Ver
    MS Office 2007
    Posts
    79
    have you tried ISBLANK funtion?

    try combining it with IF function...

    I think it may be difficult to prevent the user to skip the cell but atleast you can show a warning message
    TL

    https://sites.google.com/site/teelim/
    My page of "not so useful" spreadsheets

+ Reply to Thread

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