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
#yiv1349331506 #yiv1349331506 -- #yiv1349331506ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1349331506
#yiv1349331506ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1349331506
#yiv1349331506ygrp-mkp #yiv1349331506hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv1349331506 #yiv1349331506ygrp-mkp #yiv1349331506ads
{margin-bottom:10px;}#yiv1349331506 #yiv1349331506ygrp-mkp .yiv1349331506ad
{padding:0 0;}#yiv1349331506 #yiv1349331506ygrp-mkp .yiv1349331506ad p
{margin:0;}#yiv1349331506 #yiv1349331506ygrp-mkp .yiv1349331506ad a
{color:#0000ff;text-decoration:none;}#yiv1349331506 #yiv1349331506ygrp-sponsor
#yiv1349331506ygrp-lc {font-family:Arial;}#yiv1349331506
#yiv1349331506ygrp-sponsor #yiv1349331506ygrp-lc #yiv1349331506hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1349331506
#yiv1349331506ygrp-sponsor #yiv1349331506ygrp-lc .yiv1349331506ad
{margin-bottom:10px;padding:0 0;}#yiv1349331506 #yiv1349331506actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1349331506
#yiv1349331506activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1349331506
#yiv1349331506activity span {font-weight:700;}#yiv1349331506
#yiv1349331506activity span:first-child
{text-transform:uppercase;}#yiv1349331506 #yiv1349331506activity span a
{color:#5085b6;text-decoration:none;}#yiv1349331506 #yiv1349331506activity span
span {color:#ff7900;}#yiv1349331506 #yiv1349331506activity span
.yiv1349331506underline {text-decoration:underline;}#yiv1349331506
.yiv1349331506attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv1349331506 .yiv1349331506attach div a
{text-decoration:none;}#yiv1349331506 .yiv1349331506attach img
{border:none;padding-right:5px;}#yiv1349331506 .yiv1349331506attach label
{display:block;margin-bottom:5px;}#yiv1349331506 .yiv1349331506attach label a
{text-decoration:none;}#yiv1349331506 blockquote {margin:0 0 0
4px;}#yiv1349331506 .yiv1349331506bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv1349331506
.yiv1349331506bold a {text-decoration:none;}#yiv1349331506 dd.yiv1349331506last
p a {font-family:Verdana;font-weight:700;}#yiv1349331506 dd.yiv1349331506last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1349331506
dd.yiv1349331506last p span.yiv1349331506yshortcuts
{margin-right:0;}#yiv1349331506 div.yiv1349331506attach-table div div a
{text-decoration:none;}#yiv1349331506 div.yiv1349331506attach-table
{width:400px;}#yiv1349331506 div.yiv1349331506file-title a, #yiv1349331506
div.yiv1349331506file-title a:active, #yiv1349331506
div.yiv1349331506file-title a:hover, #yiv1349331506 div.yiv1349331506file-title
a:visited {text-decoration:none;}#yiv1349331506 div.yiv1349331506photo-title a,
#yiv1349331506 div.yiv1349331506photo-title a:active, #yiv1349331506
div.yiv1349331506photo-title a:hover, #yiv1349331506
div.yiv1349331506photo-title a:visited {text-decoration:none;}#yiv1349331506
div#yiv1349331506ygrp-mlmsg #yiv1349331506ygrp-msg p a
span.yiv1349331506yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1349331506
.yiv1349331506green {color:#628c2a;}#yiv1349331506 .yiv1349331506MsoNormal
{margin:0 0 0 0;}#yiv1349331506 o {font-size:0;}#yiv1349331506
#yiv1349331506photos div {float:left;width:72px;}#yiv1349331506
#yiv1349331506photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv1349331506
#yiv1349331506photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1349331506
#yiv1349331506reco-category {font-size:77%;}#yiv1349331506
#yiv1349331506reco-desc {font-size:77%;}#yiv1349331506 .yiv1349331506replbq
{margin:4px;}#yiv1349331506 #yiv1349331506ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv1349331506 #yiv1349331506ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1349331506
#yiv1349331506ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1349331506
#yiv1349331506ygrp-mlmsg select, #yiv1349331506 input, #yiv1349331506 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv1349331506
#yiv1349331506ygrp-mlmsg pre, #yiv1349331506 code {font:115%
monospace;}#yiv1349331506 #yiv1349331506ygrp-mlmsg *
{line-height:1.22em;}#yiv1349331506 #yiv1349331506ygrp-mlmsg #yiv1349331506logo
{padding-bottom:10px;}#yiv1349331506 #yiv1349331506ygrp-msg p a
{font-family:Verdana;}#yiv1349331506 #yiv1349331506ygrp-msg
p#yiv1349331506attach-count span {color:#1E66AE;font-weight:700;}#yiv1349331506
#yiv1349331506ygrp-reco #yiv1349331506reco-head
{color:#ff7900;font-weight:700;}#yiv1349331506 #yiv1349331506ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv1349331506 #yiv1349331506ygrp-sponsor
#yiv1349331506ov li a {font-size:130%;text-decoration:none;}#yiv1349331506
#yiv1349331506ygrp-sponsor #yiv1349331506ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv1349331506
#yiv1349331506ygrp-sponsor #yiv1349331506ov ul {margin:0;padding:0 0 0
8px;}#yiv1349331506 #yiv1349331506ygrp-text
{font-family:Georgia;}#yiv1349331506 #yiv1349331506ygrp-text p {margin:0 0 1em
0;}#yiv1349331506 #yiv1349331506ygrp-text tt {font-size:120%;}#yiv1349331506
#yiv1349331506ygrp-vital ul li:last-child {border-right:none
!important;}#yiv1349331506
