yoo nunuh, case 2 = ???? case 3 = =IF(L5="open","○",IF(L5="close","●",""))
case 4 = block all cell, klik kanan, format cells, protection, hilangkan checklist pada locked.setelahnya pilih cell yang akan di protect, klik kanan, format cells, protection, checklist pada locked setelah itu masuk ribon review, protect sheet, masukan pasword, ulangi, OK. br, odong nando Pada Sabtu, 7 November 2015 12:17, "Nunuh Sumanta nunuhassamaw...@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis: Salam sukses Para Suhu Be-Excel Kasus yg laen ..... Kriteria "minor" dan "mayor" bisa dijumlahkan berdasarkan warna secara otomatis, trs kasus selanjutnya tanda close (hitam) dan open (lingkaran) otomatis berubah juga sesuai simbol, dan kasus selanjutnya cell yg ada rumusnya pengen di password krn file ini sy kirim ke pihak ke tiga dan agar t idak dirubah krn otoritas tuk perubahan status ada pada pihak ke satu, semoga para suhu be-excel dapat memberikan solusinya ... terima kasih nunu_assamawaat #yiv7793046470 #yiv7793046470 -- #yiv7793046470ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7793046470 #yiv7793046470ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7793046470 #yiv7793046470ygrp-mkp #yiv7793046470hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7793046470 #yiv7793046470ygrp-mkp #yiv7793046470ads {margin-bottom:10px;}#yiv7793046470 #yiv7793046470ygrp-mkp .yiv7793046470ad {padding:0 0;}#yiv7793046470 #yiv7793046470ygrp-mkp .yiv7793046470ad p {margin:0;}#yiv7793046470 #yiv7793046470ygrp-mkp .yiv7793046470ad a {color:#0000ff;text-decoration:none;}#yiv7793046470 #yiv7793046470ygrp-sponsor #yiv7793046470ygrp-lc {font-family:Arial;}#yiv7793046470 #yiv7793046470ygrp-sponsor #yiv7793046470ygrp-lc #yiv7793046470hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7793046470 #yiv7793046470ygrp-sponsor #yiv7793046470ygrp-lc .yiv7793046470ad {margin-bottom:10px;padding:0 0;}#yiv7793046470 #yiv7793046470actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7793046470 #yiv7793046470activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7793046470 #yiv7793046470activity span {font-weight:700;}#yiv7793046470 #yiv7793046470activity span:first-child {text-transform:uppercase;}#yiv7793046470 #yiv7793046470activity span a {color:#5085b6;text-decoration:none;}#yiv7793046470 #yiv7793046470activity span span {color:#ff7900;}#yiv7793046470 #yiv7793046470activity span .yiv7793046470underline {text-decoration:underline;}#yiv7793046470 .yiv7793046470attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7793046470 .yiv7793046470attach div a {text-decoration:none;}#yiv7793046470 .yiv7793046470attach img {border:none;padding-right:5px;}#yiv7793046470 .yiv7793046470attach label {display:block;margin-bottom:5px;}#yiv7793046470 .yiv7793046470attach label a {text-decoration:none;}#yiv7793046470 blockquote {margin:0 0 0 4px;}#yiv7793046470 .yiv7793046470bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7793046470 .yiv7793046470bold a {text-decoration:none;}#yiv7793046470 dd.yiv7793046470last p a {font-family:Verdana;font-weight:700;}#yiv7793046470 dd.yiv7793046470last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7793046470 dd.yiv7793046470last p span.yiv7793046470yshortcuts {margin-right:0;}#yiv7793046470 div.yiv7793046470attach-table div div a {text-decoration:none;}#yiv7793046470 div.yiv7793046470attach-table {width:400px;}#yiv7793046470 div.yiv7793046470file-title a, #yiv7793046470 div.yiv7793046470file-title a:active, #yiv7793046470 div.yiv7793046470file-title a:hover, #yiv7793046470 div.yiv7793046470file-title a:visited {text-decoration:none;}#yiv7793046470 div.yiv7793046470photo-title a, #yiv7793046470 div.yiv7793046470photo-title a:active, #yiv7793046470 div.yiv7793046470photo-title a:hover, #yiv7793046470 div.yiv7793046470photo-title a:visited {text-decoration:none;}#yiv7793046470 div#yiv7793046470ygrp-mlmsg #yiv7793046470ygrp-msg p a span.yiv7793046470yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7793046470 .yiv7793046470green {color:#628c2a;}#yiv7793046470 .yiv7793046470MsoNormal {margin:0 0 0 0;}#yiv7793046470 o {font-size:0;}#yiv7793046470 #yiv7793046470photos div {float:left;width:72px;}#yiv7793046470 #yiv7793046470photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv7793046470 #yiv7793046470photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7793046470 #yiv7793046470reco-category {font-size:77%;}#yiv7793046470 #yiv7793046470reco-desc {font-size:77%;}#yiv7793046470 .yiv7793046470replbq {margin:4px;}#yiv7793046470 #yiv7793046470ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7793046470 #yiv7793046470ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7793046470 #yiv7793046470ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7793046470 #yiv7793046470ygrp-mlmsg select, #yiv7793046470 input, #yiv7793046470 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7793046470 #yiv7793046470ygrp-mlmsg pre, #yiv7793046470 code {font:115% monospace;}#yiv7793046470 #yiv7793046470ygrp-mlmsg * {line-height:1.22em;}#yiv7793046470 #yiv7793046470ygrp-mlmsg #yiv7793046470logo {padding-bottom:10px;}#yiv7793046470 #yiv7793046470ygrp-msg p a {font-family:Verdana;}#yiv7793046470 #yiv7793046470ygrp-msg p#yiv7793046470attach-count span {color:#1E66AE;font-weight:700;}#yiv7793046470 #yiv7793046470ygrp-reco #yiv7793046470reco-head {color:#ff7900;font-weight:700;}#yiv7793046470 #yiv7793046470ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7793046470 #yiv7793046470ygrp-sponsor #yiv7793046470ov li a {font-size:130%;text-decoration:none;}#yiv7793046470 #yiv7793046470ygrp-sponsor #yiv7793046470ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7793046470 #yiv7793046470ygrp-sponsor #yiv7793046470ov ul {margin:0;padding:0 0 0 8px;}#yiv7793046470 #yiv7793046470ygrp-text {font-family:Georgia;}#yiv7793046470 #yiv7793046470ygrp-text p {margin:0 0 1em 0;}#yiv7793046470 #yiv7793046470ygrp-text tt {font-size:120%;}#yiv7793046470 #yiv7793046470ygrp-vital ul li:last-child {border-right:none !important;}#yiv7793046470
mohon maaf ini file excel, mksh-1.xlsx
Description: MS-Excel 2007 spreadsheet