Dear Pak zainul,
Formulanya tidak bekerja pak. Salam, DD From: 'zainul_ulum[at]yahoo[dot]com' [email protected] [belajar-excel] [mailto:[email protected]] Sent: 22 Oktober 2014 16:40 To: [email protected] Subject: RE: [belajar-excel] Data Validation copy rumus di [L2} ke bawah dan ke kanan From: [email protected] [mailto:[email protected]] Sent: Wednesday, October 22, 2014 4:31 PM To: [email protected] Subject: [belajar-excel] Data Validation Dear BeExceller, Minta tolong master, saya ingin memprotect untuk isian dari tabel dibawah ini. Bagaimana caranya agar kolom warna kuning hanya bisa diisi kalau jenis kelamin “L”, jadi kalau jenis kelaminnya “P” cell ditak bisa diisi dikolom warna kuning. Begitupun untuk kolom warna hijau. Nama Jenis Kelamin L P a L 1 b P 1 c L 1 d P 1 e P 1 Kalau menggunakan data validasi bagaimana caranya yah, mohon masukannya. Salam, DD _____ This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual to whom it is addressed. If you have received this email in error please send it back to the person that sent it to you. Any views or opinions presented are solely those of its author and do not necessarily represent those of NABATI or any of its subsidiary companies. Unauthorized publication, use, dissemination, forwarding, printing or copying of this email and its associated attachments is strictly prohibited.
