Ooo...
ternyata syaratnya ganjil dan genap, okelah...
sedikit menyingkat formula yang sudah anda buat...
ganjil
=ISODD($A1)
genap
=ISEVEN(IF($A1="";"-";$A1))
br,
odong nando
Dari: "Hilman [email protected] [belajar-excel]"
<[email protected]>
Kepada: "[email protected]" <[email protected]>
Dikirim: Kamis, 11 Oktober 2018 13:10
Judul: Re: Bls: [belajar-excel] Conditional Formating Untuk Baris Ganjil dan
Baris Genap [1 Attachment]
Sori... formulanya baru ketemu akhirnya ...Alhamdulillah....Setelah dari
pagi nyari2... wkwkwk....
Untuk baris ganjil, pake formula ini...
=ISODD(IF(SUM($A$7:$A7)=1,1,COMBIN(COUNTA($A$7:$A7)+1,2)-COMBIN(COUNTA($A$7:$A7),2)))
untuk baris genap,
=ISEVEN(IF(SUM($A$7:$A7)=1,1,COMBIN(COUNTA($A$7:$A7)+1,2)-COMBIN(COUNTA($A$7:$A7),2)))
From: "odong nando [email protected] [belajar-excel]"
<[email protected]>
To: "[email protected]" <[email protected]>
Sent: Thursday, October 11, 2018 12:30 PM
Subject: Bls: [belajar-excel] Conditional Formating Untuk Baris Ganjil dan
Baris Genap
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
#yiv4520679981 #yiv4520679981 -- #yiv4520679981ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4520679981
#yiv4520679981ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4520679981
#yiv4520679981ygrp-mkp #yiv4520679981hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv4520679981 #yiv4520679981ygrp-mkp #yiv4520679981ads
{margin-bottom:10px;}#yiv4520679981 #yiv4520679981ygrp-mkp ..yiv4520679981ad
{padding:0 0;}#yiv4520679981 #yiv4520679981ygrp-mkp .yiv4520679981ad p
{margin:0;}#yiv4520679981 #yiv4520679981ygrp-mkp .yiv4520679981ad a
{color:#0000ff;text-decoration:none;}#yiv4520679981 #yiv4520679981ygrp-sponsor
#yiv4520679981ygrp-lc {font-family:Arial;}#yiv4520679981
#yiv4520679981ygrp-sponsor #yiv4520679981ygrp-lc #yiv4520679981hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4520679981
#yiv4520679981ygrp-sponsor #yiv4520679981ygrp-lc .yiv4520679981ad
{margin-bottom:10px;padding:0 0;}#yiv4520679981 #yiv4520679981actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4520679981
#yiv4520679981activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4520679981
#yiv4520679981activity span {font-weight:700;}#yiv4520679981
#yiv4520679981activity span:first-child
{text-transform:uppercase;}#yiv4520679981 #yiv4520679981activity span a
{color:#5085b6;text-decoration:none;}#yiv4520679981 #yiv4520679981activity span
span {color:#ff7900;}#yiv4520679981 #yiv4520679981activity span
.yiv4520679981underline {text-decoration:underline;}#yiv4520679981
.yiv4520679981attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv4520679981 .yiv4520679981attach div a
{text-decoration:none;}#yiv4520679981 .yiv4520679981attach img
{border:none;padding-right:5px;}#yiv4520679981 .yiv4520679981attach label
{display:block;margin-bottom:5px;}#yiv4520679981 .yiv4520679981attach label a
{text-decoration:none;}#yiv4520679981 blockquote {margin:0 0 0
4px;}#yiv4520679981 .yiv4520679981bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv4520679981
.yiv4520679981bold a {text-decoration:none;}#yiv4520679981 dd.yiv4520679981last
p a {font-family:Verdana;font-weight:700;}#yiv4520679981 dd.yiv4520679981last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4520679981
dd.yiv4520679981last p span.yiv4520679981yshortcuts
{margin-right:0;}#yiv4520679981 div.yiv4520679981attach-table div div a
{text-decoration:none;}#yiv4520679981 div.yiv4520679981attach-table
{width:400px;}#yiv4520679981 div.yiv4520679981file-title a, #yiv4520679981
div.yiv4520679981file-title a:active, #yiv4520679981
div.yiv4520679981file-title a:hover, #yiv4520679981 div.yiv4520679981file-title
a:visited {text-decoration:none;}#yiv4520679981 div.yiv4520679981photo-title a,
#yiv4520679981 div.yiv4520679981photo-title a:active, #yiv4520679981
div.yiv4520679981photo-title a:hover, #yiv4520679981
div.yiv4520679981photo-title a:visited {text-decoration:none;}#yiv4520679981
div#yiv4520679981ygrp-mlmsg #yiv4520679981ygrp-msg p a
span.yiv4520679981yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4520679981
.yiv4520679981green {color:#628c2a;}#yiv4520679981 .yiv4520679981MsoNormal
{margin:0 0 0 0;}#yiv4520679981 o {font-size:0;}#yiv4520679981
#yiv4520679981photos div {float:left;width:72px;}#yiv4520679981
#yiv4520679981photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv4520679981
#yiv4520679981photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4520679981
#yiv4520679981reco-category {font-size:77%;}#yiv4520679981
#yiv4520679981reco-desc {font-size:77%;}#yiv4520679981 .yiv4520679981replbq
{margin:4px;}#yiv4520679981 #yiv4520679981ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv4520679981 #yiv4520679981ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4520679981
#yiv4520679981ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4520679981
#yiv4520679981ygrp-mlmsg select, #yiv4520679981 input, #yiv4520679981 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv4520679981
#yiv4520679981ygrp-mlmsg pre, #yiv4520679981 code {font:115%
monospace;}#yiv4520679981 #yiv4520679981ygrp-mlmsg *
{line-height:1.22em;}#yiv4520679981 #yiv4520679981ygrp-mlmsg #yiv4520679981logo
{padding-bottom:10px;}#yiv4520679981 #yiv4520679981ygrp-msg p a
{font-family:Verdana;}#yiv4520679981 #yiv4520679981ygrp-msg
p#yiv4520679981attach-count span {color:#1E66AE;font-weight:700;}#yiv4520679981
#yiv4520679981ygrp-reco #yiv4520679981reco-head
{color:#ff7900;font-weight:700;}#yiv4520679981 #yiv4520679981ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv4520679981 #yiv4520679981ygrp-sponsor
#yiv4520679981ov li a {font-size:130%;text-decoration:none;}#yiv4520679981
#yiv4520679981ygrp-sponsor #yiv4520679981ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv4520679981
#yiv4520679981ygrp-sponsor #yiv4520679981ov ul {margin:0;padding:0 0 0
8px;}#yiv4520679981 #yiv4520679981ygrp-text
{font-family:Georgia;}#yiv4520679981 #yiv4520679981ygrp-text p {margin:0 0 1em
0;}#yiv4520679981 #yiv4520679981ygrp-text tt {font-size:120%;}#yiv4520679981
#yiv4520679981ygrp-vital ul li:last-child {border-right:none
!important;}#yiv4520679981
