Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    128
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Data Validation (2003)

    Loungers, I want to set up a data validation that will allow only one value to be entered into a line of cells - say C1,C2,C3, so if there is a value put into C1 & C3 an Error alert is generated. I guess that this is the best method, if there is some other method I'd be keen to know.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Data Validation (2003)

    Select the range of cells.
    Select Data | Validation...
    Select Custom from the 'Allow' dropdown list.
    Enter the following formula in the 'Formula' box:

    =COUNTA($C$1:$C$3))<2

    where $C$1:$C$3 is the range; the $ signs make the reference absolute (this is necessary, otherwise the reference will change from cell to cell)
    Activate the Error Alert tab.
    Make sure that the check box is ticked.
    Set the style to Stop, and enter an appropriate title and error message.
    Click OK.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •