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
