Hi All,
I am getting inputs from users..I am making few fields as mandatory and user has to give inputs there..
How can I generate error message if user is not giving any input on those cells?
-Sankar
Hi All,
I am getting inputs from users..I am making few fields as mandatory and user has to give inputs there..
How can I generate error message if user is not giving any input on those cells?
-Sankar
Hi
One way is using Custom Validation, to force users to type values.
Example:
In range B1:K1, don't allow to type nothing IF, A1, is empty.
So highlight B1:K1. In custom Validation rules, type =COUNTA($A$1)>0
So, if there is no text in A1, user can type nothing in this range.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks