hai hilman,
bisa banget, tinggal sediakan 2 kolom bantu, kolom refresi 1,3,5 & 2,4, degan
bantuan MATCH, tinggal di pasang k bagian yang akan di CF kan, silakan di
coba... br,
odong nando
Dari: "Hilman [email protected] [belajar-excel]"
<[email protected]>
Kepada: "[email protected]" <[email protected]>
Dikirim: Kamis, 11 Oktober 2018 10:41
Judul: Re: [belajar-excel] Conditional Formating Untuk Baris Ganjil dan Baris
Genap
Maksudnya...
Gimana caranya conditional formating untuk row yang nilainya 1,3,5 warnanya
akan kuning, sedangkan row 2,4 warnanya hijau..Jadi walaupun diinsert row pada
area ganjil ataupun area genap, warnanya akan tetap kuning atau tetap hijau….
From: "Hilman [email protected] [belajar-excel]"
<[email protected]>
To: "[email protected]" <[email protected]>
Sent: Thursday, October 11, 2018 10:40 AM
Subject: [belajar-excel] Conditional Formating Untuk Baris Ganjil dan Baris
Genap [1 Attachment]
Dear All
Gimana caranya conditional formating untuk row yang nilainya 1,3,5 warnanya
akan kuning, sedangkan row 4,5 warnanya hijau..Jadi walaupun diinsert row pada
area ganjil ataupun area genap, warnanya akan tetap kuning atau tetap hijau….
Makasih yaaa....
Setelah 5 tahunan vakum dari dunia excel, agak kagok juga nih.. dan ternyata
jadi gak tajam lagi...hehehehe....
SalamHilman
#yiv8074887865 #yiv8074887865 -- #yiv8074887865ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8074887865
#yiv8074887865ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8074887865
#yiv8074887865ygrp-mkp #yiv8074887865hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv8074887865 #yiv8074887865ygrp-mkp #yiv8074887865ads
{margin-bottom:10px;}#yiv8074887865 #yiv8074887865ygrp-mkp ..yiv8074887865ad
{padding:0 0;}#yiv8074887865 #yiv8074887865ygrp-mkp .yiv8074887865ad p
{margin:0;}#yiv8074887865 #yiv8074887865ygrp-mkp .yiv8074887865ad a
{color:#0000ff;text-decoration:none;}#yiv8074887865 #yiv8074887865ygrp-sponsor
#yiv8074887865ygrp-lc {font-family:Arial;}#yiv8074887865
#yiv8074887865ygrp-sponsor #yiv8074887865ygrp-lc #yiv8074887865hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8074887865
#yiv8074887865ygrp-sponsor #yiv8074887865ygrp-lc .yiv8074887865ad
{margin-bottom:10px;padding:0 0;}#yiv8074887865 #yiv8074887865actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8074887865
#yiv8074887865activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8074887865
#yiv8074887865activity span {font-weight:700;}#yiv8074887865
#yiv8074887865activity span:first-child
{text-transform:uppercase;}#yiv8074887865 #yiv8074887865activity span a
{color:#5085b6;text-decoration:none;}#yiv8074887865 #yiv8074887865activity span
span {color:#ff7900;}#yiv8074887865 #yiv8074887865activity span
.yiv8074887865underline {text-decoration:underline;}#yiv8074887865
.yiv8074887865attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv8074887865 .yiv8074887865attach div a
{text-decoration:none;}#yiv8074887865 .yiv8074887865attach img
{border:none;padding-right:5px;}#yiv8074887865 .yiv8074887865attach label
{display:block;margin-bottom:5px;}#yiv8074887865 .yiv8074887865attach label a
{text-decoration:none;}#yiv8074887865 blockquote {margin:0 0 0
4px;}#yiv8074887865 .yiv8074887865bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv8074887865
.yiv8074887865bold a {text-decoration:none;}#yiv8074887865 dd.yiv8074887865last
p a {font-family:Verdana;font-weight:700;}#yiv8074887865 dd.yiv8074887865last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8074887865
dd.yiv8074887865last p span.yiv8074887865yshortcuts
{margin-right:0;}#yiv8074887865 div.yiv8074887865attach-table div div a
{text-decoration:none;}#yiv8074887865 div.yiv8074887865attach-table
{width:400px;}#yiv8074887865 div.yiv8074887865file-title a, #yiv8074887865
div.yiv8074887865file-title a:active, #yiv8074887865
div.yiv8074887865file-title a:hover, #yiv8074887865 div.yiv8074887865file-title
a:visited {text-decoration:none;}#yiv8074887865 div.yiv8074887865photo-title a,
#yiv8074887865 div.yiv8074887865photo-title a:active, #yiv8074887865
div.yiv8074887865photo-title a:hover, #yiv8074887865
div.yiv8074887865photo-title a:visited {text-decoration:none;}#yiv8074887865
div#yiv8074887865ygrp-mlmsg #yiv8074887865ygrp-msg p a
span.yiv8074887865yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8074887865
.yiv8074887865green {color:#628c2a;}#yiv8074887865 .yiv8074887865MsoNormal
{margin:0 0 0 0;}#yiv8074887865 o {font-size:0;}#yiv8074887865
#yiv8074887865photos div {float:left;width:72px;}#yiv8074887865
#yiv8074887865photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv8074887865
#yiv8074887865photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8074887865
#yiv8074887865reco-category {font-size:77%;}#yiv8074887865
#yiv8074887865reco-desc {font-size:77%;}#yiv8074887865 .yiv8074887865replbq
{margin:4px;}#yiv8074887865 #yiv8074887865ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv8074887865 #yiv8074887865ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8074887865
#yiv8074887865ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8074887865
#yiv8074887865ygrp-mlmsg select, #yiv8074887865 input, #yiv8074887865 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv8074887865
#yiv8074887865ygrp-mlmsg pre, #yiv8074887865 code {font:115%
monospace;}#yiv8074887865 #yiv8074887865ygrp-mlmsg *
{line-height:1.22em;}#yiv8074887865 #yiv8074887865ygrp-mlmsg #yiv8074887865logo
{padding-bottom:10px;}#yiv8074887865 #yiv8074887865ygrp-msg p a
{font-family:Verdana;}#yiv8074887865 #yiv8074887865ygrp-msg
p#yiv8074887865attach-count span {color:#1E66AE;font-weight:700;}#yiv8074887865
#yiv8074887865ygrp-reco #yiv8074887865reco-head
{color:#ff7900;font-weight:700;}#yiv8074887865 #yiv8074887865ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv8074887865 #yiv8074887865ygrp-sponsor
#yiv8074887865ov li a {font-size:130%;text-decoration:none;}#yiv8074887865
#yiv8074887865ygrp-sponsor #yiv8074887865ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv8074887865
#yiv8074887865ygrp-sponsor #yiv8074887865ov ul {margin:0;padding:0 0 0
8px;}#yiv8074887865 #yiv8074887865ygrp-text
{font-family:Georgia;}#yiv8074887865 #yiv8074887865ygrp-text p {margin:0 0 1em
0;}#yiv8074887865 #yiv8074887865ygrp-text tt {font-size:120%;}#yiv8074887865
#yiv8074887865ygrp-vital ul li:last-child {border-right:none
!important;}#yiv8074887865
