Kayaknya harus dibuka file nya dulu om.... hehehe...
From: "odong nando [email protected] [belajar-excel]"
<[email protected]>
To: "[email protected]" <[email protected]>
Sent: Thursday, October 11, 2018 2:02 PM
Subject: Bls: Bls: [belajar-excel] Conditional Formating Untuk Baris Ganjil
dan Baris Genap
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
#yiv0340372272 #yiv0340372272 -- #yiv0340372272ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0340372272
#yiv0340372272ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0340372272
#yiv0340372272ygrp-mkp #yiv0340372272hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv0340372272 #yiv0340372272ygrp-mkp #yiv0340372272ads
{margin-bottom:10px;}#yiv0340372272 #yiv0340372272ygrp-mkp ..yiv0340372272ad
{padding:0 0;}#yiv0340372272 #yiv0340372272ygrp-mkp .yiv0340372272ad p
{margin:0;}#yiv0340372272 #yiv0340372272ygrp-mkp .yiv0340372272ad a
{color:#0000ff;text-decoration:none;}#yiv0340372272 #yiv0340372272ygrp-sponsor
#yiv0340372272ygrp-lc {font-family:Arial;}#yiv0340372272
#yiv0340372272ygrp-sponsor #yiv0340372272ygrp-lc #yiv0340372272hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0340372272
#yiv0340372272ygrp-sponsor #yiv0340372272ygrp-lc .yiv0340372272ad
{margin-bottom:10px;padding:0 0;}#yiv0340372272 #yiv0340372272actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0340372272
#yiv0340372272activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0340372272
#yiv0340372272activity span {font-weight:700;}#yiv0340372272
#yiv0340372272activity span:first-child
{text-transform:uppercase;}#yiv0340372272 #yiv0340372272activity span a
{color:#5085b6;text-decoration:none;}#yiv0340372272 #yiv0340372272activity span
span {color:#ff7900;}#yiv0340372272 #yiv0340372272activity span
.yiv0340372272underline {text-decoration:underline;}#yiv0340372272
.yiv0340372272attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv0340372272 .yiv0340372272attach div a
{text-decoration:none;}#yiv0340372272 .yiv0340372272attach img
{border:none;padding-right:5px;}#yiv0340372272 .yiv0340372272attach label
{display:block;margin-bottom:5px;}#yiv0340372272 .yiv0340372272attach label a
{text-decoration:none;}#yiv0340372272 blockquote {margin:0 0 0
4px;}#yiv0340372272 .yiv0340372272bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv0340372272
.yiv0340372272bold a {text-decoration:none;}#yiv0340372272 dd.yiv0340372272last
p a {font-family:Verdana;font-weight:700;}#yiv0340372272 dd.yiv0340372272last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0340372272
dd.yiv0340372272last p span.yiv0340372272yshortcuts
{margin-right:0;}#yiv0340372272 div.yiv0340372272attach-table div div a
{text-decoration:none;}#yiv0340372272 div.yiv0340372272attach-table
{width:400px;}#yiv0340372272 div.yiv0340372272file-title a, #yiv0340372272
div.yiv0340372272file-title a:active, #yiv0340372272
div.yiv0340372272file-title a:hover, #yiv0340372272 div.yiv0340372272file-title
a:visited {text-decoration:none;}#yiv0340372272 div.yiv0340372272photo-title a,
#yiv0340372272 div.yiv0340372272photo-title a:active, #yiv0340372272
div.yiv0340372272photo-title a:hover, #yiv0340372272
div.yiv0340372272photo-title a:visited {text-decoration:none;}#yiv0340372272
div#yiv0340372272ygrp-mlmsg #yiv0340372272ygrp-msg p a
span.yiv0340372272yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0340372272
.yiv0340372272green {color:#628c2a;}#yiv0340372272 .yiv0340372272MsoNormal
{margin:0 0 0 0;}#yiv0340372272 o {font-size:0;}#yiv0340372272
#yiv0340372272photos div {float:left;width:72px;}#yiv0340372272
#yiv0340372272photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv0340372272
#yiv0340372272photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0340372272
#yiv0340372272reco-category {font-size:77%;}#yiv0340372272
#yiv0340372272reco-desc {font-size:77%;}#yiv0340372272 .yiv0340372272replbq
{margin:4px;}#yiv0340372272 #yiv0340372272ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv0340372272 #yiv0340372272ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0340372272
#yiv0340372272ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0340372272
#yiv0340372272ygrp-mlmsg select, #yiv0340372272 input, #yiv0340372272 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv0340372272
#yiv0340372272ygrp-mlmsg pre, #yiv0340372272 code {font:115%
monospace;}#yiv0340372272 #yiv0340372272ygrp-mlmsg *
{line-height:1.22em;}#yiv0340372272 #yiv0340372272ygrp-mlmsg #yiv0340372272logo
{padding-bottom:10px;}#yiv0340372272 #yiv0340372272ygrp-msg p a
{font-family:Verdana;}#yiv0340372272 #yiv0340372272ygrp-msg
p#yiv0340372272attach-count span {color:#1E66AE;font-weight:700;}#yiv0340372272
#yiv0340372272ygrp-reco #yiv0340372272reco-head
{color:#ff7900;font-weight:700;}#yiv0340372272 #yiv0340372272ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv0340372272 #yiv0340372272ygrp-sponsor
#yiv0340372272ov li a {font-size:130%;text-decoration:none;}#yiv0340372272
#yiv0340372272ygrp-sponsor #yiv0340372272ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv0340372272
#yiv0340372272ygrp-sponsor #yiv0340372272ov ul {margin:0;padding:0 0 0
8px;}#yiv0340372272 #yiv0340372272ygrp-text
{font-family:Georgia;}#yiv0340372272 #yiv0340372272ygrp-text p {margin:0 0 1em
0;}#yiv0340372272 #yiv0340372272ygrp-text tt {font-size:120%;}#yiv0340372272
#yiv0340372272ygrp-vital ul li:last-child {border-right:none
!important;}#yiv0340372272
