Terima kasih atas bantuannya. Untuk kasus saya ini bukan numerik isinya tetapi
text. Pada intinya yg saya inginkan memberikan warna pada Kriteria berdasarkan
nilai min dan max yg sudah ditentukan. Kalau misalnya di copy paste
formattingnya saja apa bisa ? Terima kasih
On Tuesday, December 12, 2017, 8:05:34 AM GMT+7, 'Mr. Kid'
mr.nm...@gmail.com [belajar-excel] <belajar-excel@yahoogroups.com> wrote:
Hai Tommy,
Conditional Formatting (CF) memiliki batasan.
CF 2 color scale untuk berdasar nilai numerik di cells yang diberi CF
CF Use Formula bisa lebih luwes, tetapi akan cukup banyak CF yang perlu dibuat
untuk pembuatan gradasi warna.
Regards,
Kid
2017-12-11 17:46 GMT+07:00 Tommy Kurniawan master_tomm...@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com>:
Mohon bantuannya milis excel, saya ingin membuat warna gradasi berdasarkan
kriteria tertentu. Misal dalam contoh gambar ada kriteria S2, itu saya ingin
jadikan warna gradasi dari kuning cerah ke kuning agak gelap. Saya sudah punya
panduannya nilai min dan max dari RGB nya. Begitu pula kriteria S3 dan N ingin
saya ganti menjadi warna gradasi.
Terima kasih
#yiv2877490518 #yiv2877490518 -- #yiv2877490518ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2877490518
#yiv2877490518ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2877490518
#yiv2877490518ygrp-mkp #yiv2877490518hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv2877490518 #yiv2877490518ygrp-mkp #yiv2877490518ads
{margin-bottom:10px;}#yiv2877490518 #yiv2877490518ygrp-mkp .yiv2877490518ad
{padding:0 0;}#yiv2877490518 #yiv2877490518ygrp-mkp .yiv2877490518ad p
{margin:0;}#yiv2877490518 #yiv2877490518ygrp-mkp .yiv2877490518ad a
{color:#0000ff;text-decoration:none;}#yiv2877490518 #yiv2877490518ygrp-sponsor
#yiv2877490518ygrp-lc {font-family:Arial;}#yiv2877490518
#yiv2877490518ygrp-sponsor #yiv2877490518ygrp-lc #yiv2877490518hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2877490518
#yiv2877490518ygrp-sponsor #yiv2877490518ygrp-lc .yiv2877490518ad
{margin-bottom:10px;padding:0 0;}#yiv2877490518 #yiv2877490518actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2877490518
#yiv2877490518activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2877490518
#yiv2877490518activity span {font-weight:700;}#yiv2877490518
#yiv2877490518activity span:first-child
{text-transform:uppercase;}#yiv2877490518 #yiv2877490518activity span a
{color:#5085b6;text-decoration:none;}#yiv2877490518 #yiv2877490518activity span
span {color:#ff7900;}#yiv2877490518 #yiv2877490518activity span
.yiv2877490518underline {text-decoration:underline;}#yiv2877490518
.yiv2877490518attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv2877490518 .yiv2877490518attach div a
{text-decoration:none;}#yiv2877490518 .yiv2877490518attach img
{border:none;padding-right:5px;}#yiv2877490518 .yiv2877490518attach label
{display:block;margin-bottom:5px;}#yiv2877490518 .yiv2877490518attach label a
{text-decoration:none;}#yiv2877490518 blockquote {margin:0 0 0
4px;}#yiv2877490518 .yiv2877490518bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv2877490518
.yiv2877490518bold a {text-decoration:none;}#yiv2877490518 dd.yiv2877490518last
p a {font-family:Verdana;font-weight:700;}#yiv2877490518 dd.yiv2877490518last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2877490518
dd.yiv2877490518last p span.yiv2877490518yshortcuts
{margin-right:0;}#yiv2877490518 div.yiv2877490518attach-table div div a
{text-decoration:none;}#yiv2877490518 div.yiv2877490518attach-table
{width:400px;}#yiv2877490518 div.yiv2877490518file-title a, #yiv2877490518
div.yiv2877490518file-title a:active, #yiv2877490518
div.yiv2877490518file-title a:hover, #yiv2877490518 div.yiv2877490518file-title
a:visited {text-decoration:none;}#yiv2877490518 div.yiv2877490518photo-title a,
#yiv2877490518 div.yiv2877490518photo-title a:active, #yiv2877490518
div.yiv2877490518photo-title a:hover, #yiv2877490518
div.yiv2877490518photo-title a:visited {text-decoration:none;}#yiv2877490518
div#yiv2877490518ygrp-mlmsg #yiv2877490518ygrp-msg p a
span.yiv2877490518yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2877490518
.yiv2877490518green {color:#628c2a;}#yiv2877490518 .yiv2877490518MsoNormal
{margin:0 0 0 0;}#yiv2877490518 o {font-size:0;}#yiv2877490518
#yiv2877490518photos div {float:left;width:72px;}#yiv2877490518
#yiv2877490518photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv2877490518
#yiv2877490518photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2877490518
#yiv2877490518reco-category {font-size:77%;}#yiv2877490518
#yiv2877490518reco-desc {font-size:77%;}#yiv2877490518 .yiv2877490518replbq
{margin:4px;}#yiv2877490518 #yiv2877490518ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv2877490518 #yiv2877490518ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2877490518
#yiv2877490518ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2877490518
#yiv2877490518ygrp-mlmsg select, #yiv2877490518 input, #yiv2877490518 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv2877490518
#yiv2877490518ygrp-mlmsg pre, #yiv2877490518 code {font:115%
monospace;}#yiv2877490518 #yiv2877490518ygrp-mlmsg *
{line-height:1.22em;}#yiv2877490518 #yiv2877490518ygrp-mlmsg #yiv2877490518logo
{padding-bottom:10px;}#yiv2877490518 #yiv2877490518ygrp-msg p a
{font-family:Verdana;}#yiv2877490518 #yiv2877490518ygrp-msg
p#yiv2877490518attach-count span {color:#1E66AE;font-weight:700;}#yiv2877490518
#yiv2877490518ygrp-reco #yiv2877490518reco-head
{color:#ff7900;font-weight:700;}#yiv2877490518 #yiv2877490518ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv2877490518 #yiv2877490518ygrp-sponsor
#yiv2877490518ov li a {font-size:130%;text-decoration:none;}#yiv2877490518
#yiv2877490518ygrp-sponsor #yiv2877490518ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv2877490518
#yiv2877490518ygrp-sponsor #yiv2877490518ov ul {margin:0;padding:0 0 0
8px;}#yiv2877490518 #yiv2877490518ygrp-text
{font-family:Georgia;}#yiv2877490518 #yiv2877490518ygrp-text p {margin:0 0 1em
0;}#yiv2877490518 #yiv2877490518ygrp-text tt {font-size:120%;}#yiv2877490518
#yiv2877490518ygrp-vital ul li:last-child {border-right:none
!important;}#yiv2877490518
