Hey guys,
Please how can I prevent an entry in a cell even without formula
lets say cells B1 , C1 , D 1 , E1 I want to prevent an entry in these cell
and if you try an error message will display
Thanks,
Hey guys,
Please how can I prevent an entry in a cell even without formula
lets say cells B1 , C1 , D 1 , E1 I want to prevent an entry in these cell
and if you try an error message will display
Thanks,
You can use Custom Validation.
Put something like this In Custom Validation rules.
Formula:
Please Login or Register to view this content.
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