Hai Vanesya,
Silakan ikuti langkah mudah berikut :1. Blok semua sel R7:R17, Klik kanan,
Klik Copy, pindahkan kursor ke sel T7, klik kanan, Klik Paste Special, pilih
Formats, Klik OK. Jadi deh.... semoga membantu. Salam, Wid
2
On Monday, December 7, 2015 10:47 AM, "[email protected]
[belajar-excel]" <[email protected]> wrote:
HI, para Master Excel sekalian.
saya langsung saja ya ...
Bagaimana caranya pada KOLOM TOTAL PRESENTASE, warna dapat berubah secara
otomatis berdasarkan tanggal terakhir di kolom TANGGAL KEDATANGAN ??
Disini, sebagai contoh tanggal terakhir adalah tanggal 7.
Sebelumnya saya sampaikan terima kasih pada master2 sekalian
#yiv6165828273 #yiv6165828273 -- #yiv6165828273ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6165828273
#yiv6165828273ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6165828273
#yiv6165828273ygrp-mkp #yiv6165828273hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv6165828273 #yiv6165828273ygrp-mkp #yiv6165828273ads
{margin-bottom:10px;}#yiv6165828273 #yiv6165828273ygrp-mkp .yiv6165828273ad
{padding:0 0;}#yiv6165828273 #yiv6165828273ygrp-mkp .yiv6165828273ad p
{margin:0;}#yiv6165828273 #yiv6165828273ygrp-mkp .yiv6165828273ad a
{color:#0000ff;text-decoration:none;}#yiv6165828273 #yiv6165828273ygrp-sponsor
#yiv6165828273ygrp-lc {font-family:Arial;}#yiv6165828273
#yiv6165828273ygrp-sponsor #yiv6165828273ygrp-lc #yiv6165828273hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6165828273
#yiv6165828273ygrp-sponsor #yiv6165828273ygrp-lc .yiv6165828273ad
{margin-bottom:10px;padding:0 0;}#yiv6165828273 #yiv6165828273actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6165828273
#yiv6165828273activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6165828273
#yiv6165828273activity span {font-weight:700;}#yiv6165828273
#yiv6165828273activity span:first-child
{text-transform:uppercase;}#yiv6165828273 #yiv6165828273activity span a
{color:#5085b6;text-decoration:none;}#yiv6165828273 #yiv6165828273activity span
span {color:#ff7900;}#yiv6165828273 #yiv6165828273activity span
.yiv6165828273underline {text-decoration:underline;}#yiv6165828273
.yiv6165828273attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv6165828273 .yiv6165828273attach div a
{text-decoration:none;}#yiv6165828273 .yiv6165828273attach img
{border:none;padding-right:5px;}#yiv6165828273 .yiv6165828273attach label
{display:block;margin-bottom:5px;}#yiv6165828273 .yiv6165828273attach label a
{text-decoration:none;}#yiv6165828273 blockquote {margin:0 0 0
4px;}#yiv6165828273 .yiv6165828273bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv6165828273
.yiv6165828273bold a {text-decoration:none;}#yiv6165828273 dd.yiv6165828273last
p a {font-family:Verdana;font-weight:700;}#yiv6165828273 dd.yiv6165828273last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6165828273
dd.yiv6165828273last p span.yiv6165828273yshortcuts
{margin-right:0;}#yiv6165828273 div.yiv6165828273attach-table div div a
{text-decoration:none;}#yiv6165828273 div.yiv6165828273attach-table
{width:400px;}#yiv6165828273 div.yiv6165828273file-title a, #yiv6165828273
div.yiv6165828273file-title a:active, #yiv6165828273
div.yiv6165828273file-title a:hover, #yiv6165828273 div.yiv6165828273file-title
a:visited {text-decoration:none;}#yiv6165828273 div.yiv6165828273photo-title a,
#yiv6165828273 div.yiv6165828273photo-title a:active, #yiv6165828273
div.yiv6165828273photo-title a:hover, #yiv6165828273
div.yiv6165828273photo-title a:visited {text-decoration:none;}#yiv6165828273
div#yiv6165828273ygrp-mlmsg #yiv6165828273ygrp-msg p a
span.yiv6165828273yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6165828273
.yiv6165828273green {color:#628c2a;}#yiv6165828273 .yiv6165828273MsoNormal
{margin:0 0 0 0;}#yiv6165828273 o {font-size:0;}#yiv6165828273
#yiv6165828273photos div {float:left;width:72px;}#yiv6165828273
#yiv6165828273photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv6165828273
#yiv6165828273photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6165828273
#yiv6165828273reco-category {font-size:77%;}#yiv6165828273
#yiv6165828273reco-desc {font-size:77%;}#yiv6165828273 .yiv6165828273replbq
{margin:4px;}#yiv6165828273 #yiv6165828273ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv6165828273 #yiv6165828273ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6165828273
#yiv6165828273ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6165828273
#yiv6165828273ygrp-mlmsg select, #yiv6165828273 input, #yiv6165828273 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv6165828273
#yiv6165828273ygrp-mlmsg pre, #yiv6165828273 code {font:115%
monospace;}#yiv6165828273 #yiv6165828273ygrp-mlmsg *
{line-height:1.22em;}#yiv6165828273 #yiv6165828273ygrp-mlmsg #yiv6165828273logo
{padding-bottom:10px;}#yiv6165828273 #yiv6165828273ygrp-msg p a
{font-family:Verdana;}#yiv6165828273 #yiv6165828273ygrp-msg
p#yiv6165828273attach-count span {color:#1E66AE;font-weight:700;}#yiv6165828273
#yiv6165828273ygrp-reco #yiv6165828273reco-head
{color:#ff7900;font-weight:700;}#yiv6165828273 #yiv6165828273ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv6165828273 #yiv6165828273ygrp-sponsor
#yiv6165828273ov li a {font-size:130%;text-decoration:none;}#yiv6165828273
#yiv6165828273ygrp-sponsor #yiv6165828273ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv6165828273
#yiv6165828273ygrp-sponsor #yiv6165828273ov ul {margin:0;padding:0 0 0
8px;}#yiv6165828273 #yiv6165828273ygrp-text
{font-family:Georgia;}#yiv6165828273 #yiv6165828273ygrp-text p {margin:0 0 1em
0;}#yiv6165828273 #yiv6165828273ygrp-text tt {font-size:120%;}#yiv6165828273
#yiv6165828273ygrp-vital ul li:last-child {border-right:none
!important;}#yiv6165828273
