I want to restrict the user from entering a value in more than a given set of columns.
To the best of my knowledge, I can do this either using data validation OR by formula. Is there any other way ? How do I do data validation using HSSF ? OR Can I use formula for Cells in HSSF? Both the cases are mentioned below :- CASE A:- ====== I need dropdowns in Excel i.e (Thanks to Nishant Rao for this Excel tip) Data->Validation. In the Settings tab, under Validation criteria select "List" and make sure "In-cell dropdown" is selected on the right. Then you can specify what values are allowed for that cell (and hence will display in the dropdown). I want to do this in HSSF. Is it possible ? How ? CASE B :- ====== --- OR -- Can I do this Use a custom Validation criteria Formula like :- =SUM($E3:$Z3)<=1 Can I do this in HSSF? How? Please Help ! Thanks in advance, qgh __________________________________________________ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
