Cell validation!

[Kim-Anh Tran]

How do I set cell validation criteria to custom that only accept "A
value else the alert message display.
I appreciate any help!
Kim-An

 

[Frank Kabel]

Hi
assuming your cell is A1 try the following:
- select this cell
- goto 'Data - Validation - custom'
- enter the formula
=A1="A"

 

[Dave Hawley]

Hi Kim

Use

=EXACT("A",A1)

To make it case sensitive

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***

 

[Debra Dalgleish]

In the data validation dialog box, choose to Allow: List
In the Source box, type: A