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
#yiv5633965174 #yiv5633965174 -- #yiv5633965174ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5633965174
#yiv5633965174ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5633965174
#yiv5633965174ygrp-mkp #yiv5633965174hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv5633965174 #yiv5633965174ygrp-mkp #yiv5633965174ads
{margin-bottom:10px;}#yiv5633965174 #yiv5633965174ygrp-mkp ..yiv5633965174ad
{padding:0 0;}#yiv5633965174 #yiv5633965174ygrp-mkp .yiv5633965174ad p
{margin:0;}#yiv5633965174 #yiv5633965174ygrp-mkp .yiv5633965174ad a
{color:#0000ff;text-decoration:none;}#yiv5633965174 #yiv5633965174ygrp-sponsor
#yiv5633965174ygrp-lc {font-family:Arial;}#yiv5633965174
#yiv5633965174ygrp-sponsor #yiv5633965174ygrp-lc #yiv5633965174hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5633965174
#yiv5633965174ygrp-sponsor #yiv5633965174ygrp-lc .yiv5633965174ad
{margin-bottom:10px;padding:0 0;}#yiv5633965174 #yiv5633965174actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5633965174
#yiv5633965174activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5633965174
#yiv5633965174activity span {font-weight:700;}#yiv5633965174
#yiv5633965174activity span:first-child
{text-transform:uppercase;}#yiv5633965174 #yiv5633965174activity span a
{color:#5085b6;text-decoration:none;}#yiv5633965174 #yiv5633965174activity span
span {color:#ff7900;}#yiv5633965174 #yiv5633965174activity span
.yiv5633965174underline {text-decoration:underline;}#yiv5633965174
.yiv5633965174attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv5633965174 .yiv5633965174attach div a
{text-decoration:none;}#yiv5633965174 .yiv5633965174attach img
{border:none;padding-right:5px;}#yiv5633965174 .yiv5633965174attach label
{display:block;margin-bottom:5px;}#yiv5633965174 .yiv5633965174attach label a
{text-decoration:none;}#yiv5633965174 blockquote {margin:0 0 0
4px;}#yiv5633965174 .yiv5633965174bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv5633965174
.yiv5633965174bold a {text-decoration:none;}#yiv5633965174 dd.yiv5633965174last
p a {font-family:Verdana;font-weight:700;}#yiv5633965174 dd.yiv5633965174last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5633965174
dd.yiv5633965174last p span.yiv5633965174yshortcuts
{margin-right:0;}#yiv5633965174 div.yiv5633965174attach-table div div a
{text-decoration:none;}#yiv5633965174 div.yiv5633965174attach-table
{width:400px;}#yiv5633965174 div.yiv5633965174file-title a, #yiv5633965174
div.yiv5633965174file-title a:active, #yiv5633965174
div.yiv5633965174file-title a:hover, #yiv5633965174 div.yiv5633965174file-title
a:visited {text-decoration:none;}#yiv5633965174 div.yiv5633965174photo-title a,
#yiv5633965174 div.yiv5633965174photo-title a:active, #yiv5633965174
div.yiv5633965174photo-title a:hover, #yiv5633965174
div.yiv5633965174photo-title a:visited {text-decoration:none;}#yiv5633965174
div#yiv5633965174ygrp-mlmsg #yiv5633965174ygrp-msg p a
span.yiv5633965174yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5633965174
.yiv5633965174green {color:#628c2a;}#yiv5633965174 .yiv5633965174MsoNormal
{margin:0 0 0 0;}#yiv5633965174 o {font-size:0;}#yiv5633965174
#yiv5633965174photos div {float:left;width:72px;}#yiv5633965174
#yiv5633965174photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv5633965174
#yiv5633965174photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5633965174
#yiv5633965174reco-category {font-size:77%;}#yiv5633965174
#yiv5633965174reco-desc {font-size:77%;}#yiv5633965174 .yiv5633965174replbq
{margin:4px;}#yiv5633965174 #yiv5633965174ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv5633965174 #yiv5633965174ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5633965174
#yiv5633965174ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5633965174
#yiv5633965174ygrp-mlmsg select, #yiv5633965174 input, #yiv5633965174 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv5633965174
#yiv5633965174ygrp-mlmsg pre, #yiv5633965174 code {font:115%
monospace;}#yiv5633965174 #yiv5633965174ygrp-mlmsg *
{line-height:1.22em;}#yiv5633965174 #yiv5633965174ygrp-mlmsg #yiv5633965174logo
{padding-bottom:10px;}#yiv5633965174 #yiv5633965174ygrp-msg p a
{font-family:Verdana;}#yiv5633965174 #yiv5633965174ygrp-msg
p#yiv5633965174attach-count span {color:#1E66AE;font-weight:700;}#yiv5633965174
#yiv5633965174ygrp-reco #yiv5633965174reco-head
{color:#ff7900;font-weight:700;}#yiv5633965174 #yiv5633965174ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv5633965174 #yiv5633965174ygrp-sponsor
#yiv5633965174ov li a {font-size:130%;text-decoration:none;}#yiv5633965174
#yiv5633965174ygrp-sponsor #yiv5633965174ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv5633965174
#yiv5633965174ygrp-sponsor #yiv5633965174ov ul {margin:0;padding:0 0 0
8px;}#yiv5633965174 #yiv5633965174ygrp-text
{font-family:Georgia;}#yiv5633965174 #yiv5633965174ygrp-text p {margin:0 0 1em
0;}#yiv5633965174 #yiv5633965174ygrp-text tt {font-size:120%;}#yiv5633965174
#yiv5633965174ygrp-vital ul li:last-child {border-right:none
!important;}#yiv5633965174
Conditional Formating Untuk Baris ganjil dan genap.xlsx
Description: MS-Excel 2007 spreadsheet
