hehe...
ternyata otak saya yang ga nyampe...
br,
odong nando
Dari: "Hilman [email protected] [belajar-excel]"
<[email protected]>
Kepada: "[email protected]" <[email protected]>
Dikirim: Kamis, 11 Oktober 2018 17:09
Judul: Re: Bls: [belajar-excel] Conditional Formating Untuk Baris Ganjil dan
Baris Genap
Dahsyat rumus nya Guru Mr. Kids nih.....
Thanks Mr. Kids...
From: "'Mr. Kid' [email protected] [belajar-excel]"
<[email protected]>
To: BeExcel <[email protected]>
Sent: Thursday, October 11, 2018 3:14 PM
Subject: Re: Bls: [belajar-excel] Conditional Formating Untuk Baris Ganjil dan
Baris Genap
Pada ngobrolin apa to...
oh CF untuk id ganjil ya...karena datanya di-merge ?
Coba ya :1. blok semua data (baris dan kolom) [mulai dari record pertama ya] ->
beri warna kuning (sebagai genap)2. semua masih terblok, buat CF untuk ganjil
saja (gak perlu buat CF yang genap), dengan jenis CF : Use formula, isi dengan
formula ini : (misal penentu ganjil genap mulai cells A2, merged) =isodd(
lookup( 9^9 , $A$2:$A2 ) )
Sesuaikan cell mulai dalam formula dengan cell kolom penentu ganjil genap di
record pertama.
Moga-moga hasilnya sesuai kebutuhan.
Regards,Kid
On Thu, Oct 11, 2018 at 1:10 PM Hilman [email protected] [belajar-excel]
<[email protected]> wrote:
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
#yiv8888645130 #yiv8888645130 -- #yiv8888645130ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8888645130
#yiv8888645130ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8888645130
#yiv8888645130ygrp-mkp #yiv8888645130hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv8888645130 #yiv8888645130ygrp-mkp #yiv8888645130ads
{margin-bottom:10px;}#yiv8888645130 #yiv8888645130ygrp-mkp ..yiv8888645130ad
{padding:0 0;}#yiv8888645130 #yiv8888645130ygrp-mkp .yiv8888645130ad p
{margin:0;}#yiv8888645130 #yiv8888645130ygrp-mkp .yiv8888645130ad a
{color:#0000ff;text-decoration:none;}#yiv8888645130 #yiv8888645130ygrp-sponsor
#yiv8888645130ygrp-lc {font-family:Arial;}#yiv8888645130
#yiv8888645130ygrp-sponsor #yiv8888645130ygrp-lc #yiv8888645130hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8888645130
#yiv8888645130ygrp-sponsor #yiv8888645130ygrp-lc .yiv8888645130ad
{margin-bottom:10px;padding:0 0;}#yiv8888645130 #yiv8888645130actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8888645130
#yiv8888645130activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8888645130
#yiv8888645130activity span {font-weight:700;}#yiv8888645130
#yiv8888645130activity span:first-child
{text-transform:uppercase;}#yiv8888645130 #yiv8888645130activity span a
{color:#5085b6;text-decoration:none;}#yiv8888645130 #yiv8888645130activity span
span {color:#ff7900;}#yiv8888645130 #yiv8888645130activity span
.yiv8888645130underline {text-decoration:underline;}#yiv8888645130
.yiv8888645130attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv8888645130 .yiv8888645130attach div a
{text-decoration:none;}#yiv8888645130 .yiv8888645130attach img
{border:none;padding-right:5px;}#yiv8888645130 .yiv8888645130attach label
{display:block;margin-bottom:5px;}#yiv8888645130 .yiv8888645130attach label a
{text-decoration:none;}#yiv8888645130 blockquote {margin:0 0 0
4px;}#yiv8888645130 .yiv8888645130bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv8888645130
.yiv8888645130bold a {text-decoration:none;}#yiv8888645130 dd.yiv8888645130last
p a {font-family:Verdana;font-weight:700;}#yiv8888645130 dd.yiv8888645130last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8888645130
dd.yiv8888645130last p span.yiv8888645130yshortcuts
{margin-right:0;}#yiv8888645130 div.yiv8888645130attach-table div div a
{text-decoration:none;}#yiv8888645130 div.yiv8888645130attach-table
{width:400px;}#yiv8888645130 div.yiv8888645130file-title a, #yiv8888645130
div.yiv8888645130file-title a:active, #yiv8888645130
div.yiv8888645130file-title a:hover, #yiv8888645130 div.yiv8888645130file-title
a:visited {text-decoration:none;}#yiv8888645130 div.yiv8888645130photo-title a,
#yiv8888645130 div.yiv8888645130photo-title a:active, #yiv8888645130
div.yiv8888645130photo-title a:hover, #yiv8888645130
div.yiv8888645130photo-title a:visited {text-decoration:none;}#yiv8888645130
div#yiv8888645130ygrp-mlmsg #yiv8888645130ygrp-msg p a
span.yiv8888645130yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8888645130
.yiv8888645130green {color:#628c2a;}#yiv8888645130 .yiv8888645130MsoNormal
{margin:0 0 0 0;}#yiv8888645130 o {font-size:0;}#yiv8888645130
#yiv8888645130photos div {float:left;width:72px;}#yiv8888645130
#yiv8888645130photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv8888645130
#yiv8888645130photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8888645130
#yiv8888645130reco-category {font-size:77%;}#yiv8888645130
#yiv8888645130reco-desc {font-size:77%;}#yiv8888645130 .yiv8888645130replbq
{margin:4px;}#yiv8888645130 #yiv8888645130ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv8888645130 #yiv8888645130ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8888645130
#yiv8888645130ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8888645130
#yiv8888645130ygrp-mlmsg select, #yiv8888645130 input, #yiv8888645130 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv8888645130
#yiv8888645130ygrp-mlmsg pre, #yiv8888645130 code {font:115%
monospace;}#yiv8888645130 #yiv8888645130ygrp-mlmsg *
{line-height:1.22em;}#yiv8888645130 #yiv8888645130ygrp-mlmsg #yiv8888645130logo
{padding-bottom:10px;}#yiv8888645130 #yiv8888645130ygrp-msg p a
{font-family:Verdana;}#yiv8888645130 #yiv8888645130ygrp-msg
p#yiv8888645130attach-count span {color:#1E66AE;font-weight:700;}#yiv8888645130
#yiv8888645130ygrp-reco #yiv8888645130reco-head
{color:#ff7900;font-weight:700;}#yiv8888645130 #yiv8888645130ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv8888645130 #yiv8888645130ygrp-sponsor
#yiv8888645130ov li a {font-size:130%;text-decoration:none;}#yiv8888645130
#yiv8888645130ygrp-sponsor #yiv8888645130ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv8888645130
#yiv8888645130ygrp-sponsor #yiv8888645130ov ul {margin:0;padding:0 0 0
8px;}#yiv8888645130 #yiv8888645130ygrp-text
{font-family:Georgia;}#yiv8888645130 #yiv8888645130ygrp-text p {margin:0 0 1em
0;}#yiv8888645130 #yiv8888645130ygrp-text tt {font-size:120%;}#yiv8888645130
#yiv8888645130ygrp-vital ul li:last-child {border-right:none
!important;}#yiv8888645130
