Pak Suyono, Pak Rohman
 

 Tolong di -share juga dong file formulanya, 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 
https://groups.yahoo.com/neo/groups/belajar-excel/conversations/messages/37723
------------



 


 Pada Kamis, 3 September 2015 17:34, "Oman Rohman [email protected] 
[belajar-excel]" menulis:
 
 

   Terima kasih banyak atas bantuannya Mas Suyono, sudah saya coba dan 
Alhamdulillah sesuai dengan keinginan 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 [1 
Attachment]
 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 
 
 
 
 

 
 



 
 
 



Kirim email ke