Conditional validation?

[PayeDoc]

Hello All

I have a sheet that is essentially just columns of data (except for the
column headings in the first row), and two of the columns are what I would
call 'mutually exclusive': i.e. if a value is entered in a row in either
column, the user must be prevented from entering any value in the same row
of the other column. The two columns already have some basic validation
applied (ranges of permissable numerical values), and this validation would
need to be applied for any values that are entered.

I am sure this can be done, but cannot see how!

Hope someone can help.
Many thanks
Leslie Isaacs

 

[Herbert Seidenberg]

Excel 2007 Validation
Conditional drop-down list.
http://www.mediafire.com/file/zmdmyqiekzw/11_10_09.xlsx

 

[Otto Moehrbach]

Herbert
I'm learning 2007. How does your "conditional drop-down list" work?
Thanks for your time. Otto

 

[Herbert Seidenberg]

Otto,
The linked file has 2 sheets that are functionally equivalent.
Sheet "Regular" is in Excel 2003 format,
sheet "Tables" in 2007 format.
You might want to compare the two.
http://www.mediafire.com/file/zmdmyqiekzw/11_10_09.xlsx
Herb

 

[Leslie Isaacs]

Hello

Many thanks for your reply.

Unfortunately I am unable to open the file at the reference you gave. After
saving it then renaming it (by removing the final 'x' from the suffix), I
just get the message that it is not in a recognizable format.

Could you possibly just let me have a pointer as to how I can get the
validadtion I need.

Thanks again for your help.
Leslie Isaacs

 

[Otto Moehrbach]

Leslie
The file that Herb gave you is an Excel 2007 file. You obviously have
an earlier version of Excel. Simply take Herb's file to someone you know
who has 2007. Have him open the file and save it in the version you have.
Done. Come back if you cannot do the above or maybe Herb can give you a
file in your version. Otto

 

[Peo Sjoblom]

Or download a conversion from MS


http://www.microsoft.com/downloads/...f0-70e5-4595-8a98-370278f40c57&DisplayLang=en


of course if this can only be done in 2007 then it will be stripped off when
it is converted to 2003 and earlier

--


Regards,


Peo Sjoblom

 

[Gord Dibben]

You will encounter this more frequently.

Download and install the Compatibility Pack so's you can open 2007 files in
2003.

http://support.microsoft.com/kb/923505

Just note that 2007 files opened in 2003 will have the columns and rows
limits of 2003.


Gord Dibben MS Excel MVP

 

[Leslie Isaacs]

Hello

Many thanks to all of you who have responded to this.

Herbert: I have downloaded and installed the Compatibility Pack, but I still
can't open the file. Any chance of an excel 2000 version?
Otto: you said to come back if I couldn't open Herb's file. I'm back!

Thanks for your continued help.
Leslie Isaacs

 

[Otto Moehrbach]

Leslie
Send me an email and I'll send you Herb's file converted to your
version. My email is (e-mail address removed). Remove the "extra"
from this address. HTH Otto