Pagi Pak Agus,
Terimakasih atas bantuannya , pertanyaan berikutnya bagaimana dengan yang di
kolom format applie from ... setiap absoulut di hilangkan dan klik apply pasti
akan muncul lagi.
Mohon pencerahannya lagi
terimakasih
On Tuesday, May 10, 2016 7:55 AM, "nangagus nanga...@gmail.com
[belajar-excel]" <belajar-excel@yahoogroups.com> wrote:
Dear Abang,
Coba ganti formula di Conditional formating: =$N$4="Open" menjadi =$N4="Open"
ganti juga untuk conditional yang lain yaaa....
salam
Agus
On 10/05/2016 1:29, Abang Jakarta abang_jakart...@yahoo.com [belajar-excel]
wrote:
Dear Master Excel
Saya mohon bantuannya, bagaimana cara meng copy formula conditional
formatting dibawah ini ke dalam cell lainnya di dalam worksheet. Saya coba
dengan format pointer tapi formula tidak berfungsi seperti di cell sebelumnya.
terimakasih
#yiv4318676020 #yiv4318676020 -- #yiv4318676020ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4318676020
#yiv4318676020ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4318676020
#yiv4318676020ygrp-mkp #yiv4318676020hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv4318676020 #yiv4318676020ygrp-mkp #yiv4318676020ads
{margin-bottom:10px;}#yiv4318676020 #yiv4318676020ygrp-mkp .yiv4318676020ad
{padding:0 0;}#yiv4318676020 #yiv4318676020ygrp-mkp .yiv4318676020ad p
{margin:0;}#yiv4318676020 #yiv4318676020ygrp-mkp .yiv4318676020ad a
{color:#0000ff;text-decoration:none;}#yiv4318676020 #yiv4318676020ygrp-sponsor
#yiv4318676020ygrp-lc {font-family:Arial;}#yiv4318676020
#yiv4318676020ygrp-sponsor #yiv4318676020ygrp-lc #yiv4318676020hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4318676020
#yiv4318676020ygrp-sponsor #yiv4318676020ygrp-lc .yiv4318676020ad
{margin-bottom:10px;padding:0 0;}#yiv4318676020 #yiv4318676020actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4318676020
#yiv4318676020activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4318676020
#yiv4318676020activity span {font-weight:700;}#yiv4318676020
#yiv4318676020activity span:first-child
{text-transform:uppercase;}#yiv4318676020 #yiv4318676020activity span a
{color:#5085b6;text-decoration:none;}#yiv4318676020 #yiv4318676020activity span
span {color:#ff7900;}#yiv4318676020 #yiv4318676020activity span
.yiv4318676020underline {text-decoration:underline;}#yiv4318676020
.yiv4318676020attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv4318676020 .yiv4318676020attach div a
{text-decoration:none;}#yiv4318676020 .yiv4318676020attach img
{border:none;padding-right:5px;}#yiv4318676020 .yiv4318676020attach label
{display:block;margin-bottom:5px;}#yiv4318676020 .yiv4318676020attach label a
{text-decoration:none;}#yiv4318676020 blockquote {margin:0 0 0
4px;}#yiv4318676020 .yiv4318676020bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv4318676020
.yiv4318676020bold a {text-decoration:none;}#yiv4318676020 dd.yiv4318676020last
p a {font-family:Verdana;font-weight:700;}#yiv4318676020 dd.yiv4318676020last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4318676020
dd.yiv4318676020last p span.yiv4318676020yshortcuts
{margin-right:0;}#yiv4318676020 div.yiv4318676020attach-table div div a
{text-decoration:none;}#yiv4318676020 div.yiv4318676020attach-table
{width:400px;}#yiv4318676020 div.yiv4318676020file-title a, #yiv4318676020
div.yiv4318676020file-title a:active, #yiv4318676020
div.yiv4318676020file-title a:hover, #yiv4318676020 div.yiv4318676020file-title
a:visited {text-decoration:none;}#yiv4318676020 div.yiv4318676020photo-title a,
#yiv4318676020 div.yiv4318676020photo-title a:active, #yiv4318676020
div.yiv4318676020photo-title a:hover, #yiv4318676020
div.yiv4318676020photo-title a:visited {text-decoration:none;}#yiv4318676020
div#yiv4318676020ygrp-mlmsg #yiv4318676020ygrp-msg p a
span.yiv4318676020yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4318676020
.yiv4318676020green {color:#628c2a;}#yiv4318676020 .yiv4318676020MsoNormal
{margin:0 0 0 0;}#yiv4318676020 o {font-size:0;}#yiv4318676020
#yiv4318676020photos div {float:left;width:72px;}#yiv4318676020
#yiv4318676020photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv4318676020
#yiv4318676020photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4318676020
#yiv4318676020reco-category {font-size:77%;}#yiv4318676020
#yiv4318676020reco-desc {font-size:77%;}#yiv4318676020 .yiv4318676020replbq
{margin:4px;}#yiv4318676020 #yiv4318676020ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv4318676020 #yiv4318676020ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4318676020
#yiv4318676020ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4318676020
#yiv4318676020ygrp-mlmsg select, #yiv4318676020 input, #yiv4318676020 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv4318676020
#yiv4318676020ygrp-mlmsg pre, #yiv4318676020 code {font:115%
monospace;}#yiv4318676020 #yiv4318676020ygrp-mlmsg *
{line-height:1.22em;}#yiv4318676020 #yiv4318676020ygrp-mlmsg #yiv4318676020logo
{padding-bottom:10px;}#yiv4318676020 #yiv4318676020ygrp-msg p a
{font-family:Verdana;}#yiv4318676020 #yiv4318676020ygrp-msg
p#yiv4318676020attach-count span {color:#1E66AE;font-weight:700;}#yiv4318676020
#yiv4318676020ygrp-reco #yiv4318676020reco-head
{color:#ff7900;font-weight:700;}#yiv4318676020 #yiv4318676020ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv4318676020 #yiv4318676020ygrp-sponsor
#yiv4318676020ov li a {font-size:130%;text-decoration:none;}#yiv4318676020
#yiv4318676020ygrp-sponsor #yiv4318676020ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv4318676020
#yiv4318676020ygrp-sponsor #yiv4318676020ov ul {margin:0;padding:0 0 0
8px;}#yiv4318676020 #yiv4318676020ygrp-text
{font-family:Georgia;}#yiv4318676020 #yiv4318676020ygrp-text p {margin:0 0 1em
0;}#yiv4318676020 #yiv4318676020ygrp-text tt {font-size:120%;}#yiv4318676020
#yiv4318676020ygrp-vital ul li:last-child {border-right:none
!important;}#yiv4318676020
