Data validation varies based on cell data entered

[WaltW]

In Excel, is there any way to customize data validation for one cell based on the data entered in another? For example, if I enter "AAA" in cell A1, I want one set of data validation choices for cell A2, but if I enter "BBB" in cell A1, I want a different set of data validation choices for A2. Any suggestions would be very much appreciated. Thanks!

Walt

 

[SkipVought]

Hi,

Check out

http://www.contextures.com/tiptech.html

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[WaltW]

Thanks, Skip. Looks like this site has just what I need!

-Walt