+ Reply to Thread
Results 1 to 10 of 10

Data Validation - how to ignore cells with "0" or "-"

Hybrid View

dgibney Data Validation - how to... 01-29-2015, 12:31 PM
mcmahobt Re: Data Validation - how to... 01-29-2015, 12:43 PM
dgibney Re: Data Validation - how to... 01-29-2015, 01:32 PM
mcmahobt Re: Data Validation - how to... 01-29-2015, 01:48 PM
dgibney Re: Data Validation - how to... 01-29-2015, 06:44 PM
dgibney Re: Data Validation - how to... 01-29-2015, 06:45 PM
FDibbins Re: Data Validation - how to... 01-29-2015, 06:53 PM
dgibney Re: Data Validation - how to... 01-29-2015, 07:24 PM
FDibbins Re: Data Validation - how to... 01-29-2015, 07:55 PM
dgibney Re: Data Validation - how to... 01-29-2015, 08:16 PM
  1. #1
    Forum Contributor
    Join Date
    05-23-2014
    Location
    Fredericia, Denmark
    MS-Off Ver
    Windows Office 2013, Excel 10
    Posts
    139

    Re: Data Validation - how to ignore cells with "0" or "-"

    Data validation is required but combined with the formula in C1 was the best I could come up. I tried various configurations of IF(OR, IF(AND conditional statement formulas but failed to come up with one that would work. The data entry into cells A1 and B1 will probably be manual and I simply need a means of blocking entry of non-zero values into both cells. I also would prefer to avoid VBA as this spreadsheet will be used and re-used by many people over time with rows and columns being added perhaps. Can you provide a formula in C1, and perhaps conditional formatting for A1 and B1 that will work?

    Thanks for your input. David

  2. #2
    Forum Contributor
    Join Date
    05-23-2014
    Location
    Fredericia, Denmark
    MS-Off Ver
    Windows Office 2013, Excel 10
    Posts
    139

    Re: Data Validation - how to ignore cells with "0" or "-"

    I meant Data Validation is NOT required.... sorry.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Counting data only contains text (ignore mark "-" & "")
    By Jhon Mustofa in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-12-2014, 09:45 PM
  2. Replies: 1
    Last Post: 10-23-2013, 05:20 PM
  3. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  4. [SOLVED] Data validation: allow entry into a cell if other three cells have "X", "Y" and "Z"?
    By RogerRangeRover in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-05-2013, 04:49 AM
  5. [SOLVED] Manually fill up 1 or (some) cells with just "BFW"or"BF" in data validation
    By robke1960 in forum Non English Excel
    Replies: 2
    Last Post: 12-11-2012, 11:31 AM

Tags for this Thread

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