Mantab..Terima kasih banyak atas bantuan & tanggapannya Pak.. Regards,
Teguh
Pada Senin, 19 Oktober 2015 15:18, "SUYONO [email protected]
[belajar-excel]" <[email protected]> menulis:
Ini Pak Teguh filenya. From:[email protected]
[mailto:[email protected]]
Sent: Monday, October 19, 2015 1:45 PM
To: [email protected]
Subject: Bls: [belajar-excel] Mewarnai font sebagai status isian user Pak
Suyono, Pak Rohman Tolong di -share juga dong fileformulanya, kebetulan saya
mempunyai permasalahan yang sama dengan Pak Rohman. Terima Kasih.
Regards, Teguh ---Mods ---
Silakan lihat di :
https://groups.yahoo.com/neo/groups/belajar-excel/conversations/messages/37723
------------
Pada Kamis, 3 September 201517:34, "Oman Rohman [email protected]
[belajar-excel]" menulis: Terima kasih banyakatas bantuannya Mas Suyono,
sudah saya coba dan Alhamdulillah sesuai dengankeinginan saya. Sekali lagi
terima kasih banyak atas solusinya.
--------------------------------------------
Pada Kam, 3/9/15, SUYONO [email protected] [belajar-excel] menulis:
Judul: RE: [belajar-excel] Mewarnai font sebagai status isian user [1Attachment]
Kepada: "[email protected]"
Tanggal: Kamis, 3 September, 2015, 3:16 PM
Assalamu'alaikum, Wr.
Wb
Coba seperti ini Pak Oman, semoga
sesuai keinginan.
Wassalam,
Suyono
From:
[email protected]
[mailto:[email protected]]
Sent: Thursday, September 03, 2015 2:23 PM
To: [email protected]
Subject: [belajar-excel] Mewarnai font sebagai status
isian user [1
Attachment]
Assalamu'alaikum, Wr. Wb. Dear para master Excel..
Mohon maaf sebelumnya
nich, saya mau merepotkan, saya mempunyai sedikit
permasalahan, sudah saya coba
otak atik tetapi mentok. Jadi dengan hormat mohon bantuannya
untuk memberikan
solusi.. permasalahan dan keterangannya ada pada lampiran.
Sebelumnya saya
ucapkan terima kasih atas bantuannya. Wassalam, Oman
Rohman
#yiv8367257942 #yiv8367257942 --
#yiv8367257942ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}
#yiv8367257942 #yiv8367257942ygrp-mkp hr {
border:1px solid #d8d8d8;}
#yiv8367257942 #yiv8367257942ygrp-mkp #yiv8367257942hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}
#yiv8367257942 #yiv8367257942ygrp-mkp #yiv8367257942ads {
margin-bottom:10px;}
#yiv8367257942 #yiv8367257942ygrp-mkp .yiv8367257942ad {
padding:0 0;}
#yiv8367257942 #yiv8367257942ygrp-mkp .yiv8367257942ad p {
margin:0;}
#yiv8367257942 #yiv8367257942ygrp-mkp .yiv8367257942ad a {
color:#0000ff;text-decoration:none;}
#yiv8367257942 #yiv8367257942ygrp-sponsor
#yiv8367257942ygrp-lc {
font-family:Arial;}
#yiv8367257942 #yiv8367257942ygrp-sponsor
#yiv8367257942ygrp-lc #yiv8367257942hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}
#yiv8367257942 #yiv8367257942ygrp-sponsor
#yiv8367257942ygrp-lc .yiv8367257942ad {
margin-bottom:10px;padding:0 0;}
#yiv8367257942 #yiv8367257942actions {
font-family:Verdana;font-size:11px;padding:10px 0;}
#yiv8367257942 #yiv8367257942activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}
#yiv8367257942 #yiv8367257942activity span {
font-weight:700;}
#yiv8367257942 #yiv8367257942activity span:first-child {
text-transform:uppercase;}
#yiv8367257942 #yiv8367257942activity span a {
color:#5085b6;text-decoration:none;}
#yiv8367257942 #yiv8367257942activity span span {
color:#ff7900;}
#yiv8367257942 #yiv8367257942activity span
.yiv8367257942underline {
text-decoration:underline;}
#yiv8367257942 .yiv8367257942attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}
#yiv8367257942 .yiv8367257942attach div a {
text-decoration:none;}
#yiv8367257942 .yiv8367257942attach img {
border:none;padding-right:5px;}
#yiv8367257942 .yiv8367257942attach label {
display:block;margin-bottom:5px;}
#yiv8367257942 .yiv8367257942attach label a {
text-decoration:none;}
#yiv8367257942 blockquote {
margin:0 0 0 4px;}
#yiv8367257942 .yiv8367257942bold {
font-family:Arial;font-size:13px;font-weight:700;}
#yiv8367257942 .yiv8367257942bold a {
text-decoration:none;}
#yiv8367257942 dd.yiv8367257942last p a {
font-family:Verdana;font-weight:700;}
#yiv8367257942 dd.yiv8367257942last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}
#yiv8367257942 dd.yiv8367257942last p
span.yiv8367257942yshortcuts {
margin-right:0;}
#yiv8367257942 div.yiv8367257942attach-table div div a {
text-decoration:none;}
#yiv8367257942 div.yiv8367257942attach-table {
width:400px;}
#yiv8367257942 div.yiv8367257942file-title a, #yiv8367257942
div.yiv8367257942file-title a:active, #yiv8367257942
div.yiv8367257942file-title a:hover, #yiv8367257942
div.yiv8367257942file-title a:visited {
text-decoration:none;}
#yiv8367257942 div.yiv8367257942photo-title a,
#yiv8367257942 div.yiv8367257942photo-title a:active,
#yiv8367257942 div.yiv8367257942photo-title a:hover,
#yiv8367257942 div.yiv8367257942photo-title a:visited {
text-decoration:none;}
#yiv8367257942 div#yiv8367257942ygrp-mlmsg
#yiv8367257942ygrp-msg p a span.yiv8367257942yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}
#yiv8367257942 .yiv8367257942green {
color:#628c2a;}
#yiv8367257942 .yiv8367257942MsoNormal {
margin:0 0 0 0;}
#yiv8367257942 o {
font-size:0;}
#yiv8367257942 #yiv8367257942photos div {
float:left;width:72px;}
#yiv8367257942 #yiv8367257942photos div div {
border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}
#yiv8367257942 #yiv8367257942photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}
#yiv8367257942 #yiv8367257942reco-category {
font-size:77%;}
#yiv8367257942 #yiv8367257942reco-desc {
font-size:77%;}
#yiv8367257942 .yiv8367257942replbq {
margin:4px;}
#yiv8367257942 #yiv8367257942ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}
#yiv8367257942 #yiv8367257942ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}
#yiv8367257942 #yiv8367257942ygrp-mlmsg table {
font-size:inherit;font:100%;}
#yiv8367257942 #yiv8367257942ygrp-mlmsg select,
#yiv8367257942 input, #yiv8367257942 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}
#yiv8367257942 #yiv8367257942ygrp-mlmsg pre, #yiv8367257942
code {
font:115% monospace;}
#yiv8367257942 #yiv8367257942ygrp-mlmsg * {
line-height:1.22em;}
#yiv8367257942 #yiv8367257942ygrp-mlmsg #yiv8367257942logo {
padding-bottom:10px;}
#yiv8367257942 #yiv8367257942ygrp-msg p a {
font-family:Verdana;}
#yiv8367257942 #yiv8367257942ygrp-msg
p#yiv8367257942attach-count span {
color:#1E66AE;font-weight:700;}
#yiv8367257942 #yiv8367257942ygrp-reco
#yiv8367257942reco-head {
color:#ff7900;font-weight:700;}
#yiv8367257942 #yiv8367257942ygrp-reco {
margin-bottom:20px;padding:0px;}
#yiv8367257942 #yiv8367257942ygrp-sponsor #yiv8367257942ov
li a {
font-size:130%;text-decoration:none;}
#yiv8367257942 #yiv8367257942ygrp-sponsor #yiv8367257942ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}
#yiv8367257942 #yiv8367257942ygrp-sponsor #yiv8367257942ov
ul {
margin:0;padding:0 0 0 8px;}
#yiv8367257942 #yiv8367257942ygrp-text {
font-family:Georgia;}
#yiv8367257942 #yiv8367257942ygrp-text p {
margin:0 0 1em 0;}
#yiv8367257942 #yiv8367257942ygrp-text tt {
font-size:120%;}
#yiv8367257942 #yiv8367257942ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv8367257942 #yiv0002101257 #yiv0002101257 -- #yiv0002101257ygrp-mkp
{border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0
10px;}#yiv0002101257 #yiv0002101257ygrp-mkp hr {border:1px solid
#d8d8d8;}#yiv0002101257 #yiv0002101257ygrp-mkp #yiv0002101257hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv0002101257 #yiv0002101257ygrp-mkp #yiv0002101257ads
{margin-bottom:10px;}#yiv0002101257 #yiv0002101257ygrp-mkp .yiv0002101257ad
{padding:0 0;}#yiv0002101257 #yiv0002101257ygrp-mkp .yiv0002101257ad p
{margin:0;}#yiv0002101257 #yiv0002101257ygrp-mkp .yiv0002101257ad a
{color:#0000ff;text-decoration:none;}#yiv0002101257 #yiv0002101257ygrp-sponsor
#yiv0002101257ygrp-lc {font-family:Arial;}#yiv0002101257
#yiv0002101257ygrp-sponsor #yiv0002101257ygrp-lc #yiv0002101257hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0002101257
#yiv0002101257ygrp-sponsor #yiv0002101257ygrp-lc .yiv0002101257ad
{margin-bottom:10px;padding:0 0;}#yiv0002101257 #yiv0002101257actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0002101257
#yiv0002101257activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0002101257
#yiv0002101257activity span {font-weight:700;}#yiv0002101257
#yiv0002101257activity span:first-child
{text-transform:uppercase;}#yiv0002101257 #yiv0002101257activity span a
{color:#5085b6;text-decoration:none;}#yiv0002101257 #yiv0002101257activity span
span {color:#ff7900;}#yiv0002101257 #yiv0002101257activity span
.yiv0002101257underline {text-decoration:underline;}#yiv0002101257
.yiv0002101257attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv0002101257 .yiv0002101257attach div a
{text-decoration:none;}#yiv0002101257 .yiv0002101257attach img
{border:none;padding-right:5px;}#yiv0002101257 .yiv0002101257attach label
{display:block;margin-bottom:5px;}#yiv0002101257 .yiv0002101257attach label a
{text-decoration:none;}#yiv0002101257 blockquote {margin:0 0 0
4px;}#yiv0002101257 .yiv0002101257bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv0002101257
.yiv0002101257bold a {text-decoration:none;}#yiv0002101257 dd.yiv0002101257last
p a {font-family:Verdana;font-weight:700;}#yiv0002101257 dd.yiv0002101257last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0002101257
dd.yiv0002101257last p span.yiv0002101257yshortcuts
{margin-right:0;}#yiv0002101257 div.yiv0002101257attach-table div div a
{text-decoration:none;}#yiv0002101257 div.yiv0002101257attach-table
{width:400px;}#yiv0002101257 div.yiv0002101257file-title a, #yiv0002101257
div.yiv0002101257file-title a:active, #yiv0002101257
div.yiv0002101257file-title a:hover, #yiv0002101257 div.yiv0002101257file-title
a:visited {text-decoration:none;}#yiv0002101257 div.yiv0002101257photo-title a,
#yiv0002101257 div.yiv0002101257photo-title a:active, #yiv0002101257
div.yiv0002101257photo-title a:hover, #yiv0002101257
div.yiv0002101257photo-title a:visited {text-decoration:none;}#yiv0002101257
div#yiv0002101257ygrp-mlmsg #yiv0002101257ygrp-msg p a
span.yiv0002101257yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0002101257
.yiv0002101257green {color:#628c2a;}#yiv0002101257 .yiv0002101257MsoNormal
{margin:0 0 0 0;}#yiv0002101257 o {font-size:0;}#yiv0002101257
#yiv0002101257photos div {float:left;width:72px;}#yiv0002101257
#yiv0002101257photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv0002101257
#yiv0002101257photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0002101257
#yiv0002101257reco-category {font-size:77%;}#yiv0002101257
#yiv0002101257reco-desc {font-size:77%;}#yiv0002101257 .yiv0002101257replbq
{margin:4px;}#yiv0002101257 #yiv0002101257ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv0002101257 #yiv0002101257ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0002101257
#yiv0002101257ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0002101257
#yiv0002101257ygrp-mlmsg select, #yiv0002101257 input, #yiv0002101257 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv0002101257
#yiv0002101257ygrp-mlmsg pre, #yiv0002101257 code {font:115%
monospace;}#yiv0002101257 #yiv0002101257ygrp-mlmsg *
{line-height:1.22em;}#yiv0002101257 #yiv0002101257ygrp-mlmsg #yiv0002101257logo
{padding-bottom:10px;}#yiv0002101257 #yiv0002101257ygrp-msg p a
{font-family:Verdana;}#yiv0002101257 #yiv0002101257ygrp-msg
p#yiv0002101257attach-count span {color:#1E66AE;font-weight:700;}#yiv0002101257
#yiv0002101257ygrp-reco #yiv0002101257reco-head
{color:#ff7900;font-weight:700;}#yiv0002101257 #yiv0002101257ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv0002101257 #yiv0002101257ygrp-sponsor
#yiv0002101257ov li a {font-size:130%;text-decoration:none;}#yiv0002101257
#yiv0002101257ygrp-sponsor #yiv0002101257ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv0002101257
#yiv0002101257ygrp-sponsor #yiv0002101257ov ul {margin:0;padding:0 0 0
8px;}#yiv0002101257 #yiv0002101257ygrp-text
{font-family:Georgia;}#yiv0002101257 #yiv0002101257ygrp-text p {margin:0 0 1em
0;}#yiv0002101257 #yiv0002101257ygrp-text tt {font-size:120%;}#yiv0002101257
#yiv0002101257ygrp-vital ul li:last-child {border-right:none
!important;}#yiv0002101257
