cells

[clumein2]

I know it must in the 'Data' 'Validation'... but I can't figure it out. I try the custom but I don't know what to enter. (sifting thru help for 30 mins)

I need something simple.... I would like a cell to only allow and entry of 'either 1, or 2. That's it......

Thanks again for your help

Cliff

 

[orbea_adam]

Cliff,
Data>Validation>Settings tab, Allow: Whole Number, Data: between, Min: 1, Max: 2

 

[Smitty]

Try:

Data-->Validation-->Settings-->Allow-->Whole Number-->Data-->Between-->Minimum-->1-->Maximum-->2.

Add your error message as needed.

Hope that helps,

Smitty

 

[Smitty]

Always several ways to skin a cat in Excel. Nice one!

Smitty

 

[clumein2]

Thanks pennysave & orbea - works great! One more quicky....

What par Data Validation do I use to ONLY enter the letters: CC or GC or T or PL?

thanks thanks thanks

cliff

 

[agihcam]

Allow List then type the text separate dwith comma

 

[orbea_adam]

Thanks pennysave & orbea - works great! One more quicky....

What par Data Validation do I use to ONLY enter the letters: CC or GC or T or PL?

thanks thanks thanks

cliff

Enter those choices in a range, one on top of the other so it makes a list, then name that range, then use: Allow>List, Source>enter named range.

You may want to uncheck "in cell dropdown"

 

[clumein2]

Thanks guys...... who needs user manuels with you folks around..... besides I never felt stupider than when reading about Excel Formulas & Functions.....

all the best