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