Wah, terimakasih banyak bang, sangat membantu .... Problem solved

Dikirim dari Yahoo Mail di Android 
 
  Pada Rab, 4 Nov 2020 pada 5:59, HERIS PAMUNTJAR [email protected] 
[XL-mania]<[email protected]> menulis:       

beginikah? 

    On Sunday, October 25, 2020, 11:07:22 AM GMT+7, Supriyadi 
[email protected] [XL-mania] <[email protected]> wrote:  
 
     

dear all,
bagaimana ya rumus atau cara untuk conditional format, agar hanya data paling 
ujung di dalam satu baris yg berubah warna,dan sebelumnya saya ucapkan 
terimakasih, untuk semua

Best Regards, 
Supriyadi 


      #yiv6677201616 #yiv6677201616 -- #yiv6677201616ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6677201616 
#yiv6677201616ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6677201616 
#yiv6677201616ygrp-mkp #yiv6677201616hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv6677201616 #yiv6677201616ygrp-mkp #yiv6677201616ads 
{margin-bottom:10px;}#yiv6677201616 #yiv6677201616ygrp-mkp .yiv6677201616ad 
{padding:0 0;}#yiv6677201616 #yiv6677201616ygrp-mkp .yiv6677201616ad p 
{margin:0;}#yiv6677201616 #yiv6677201616ygrp-mkp .yiv6677201616ad a 
{color:#0000ff;text-decoration:none;}#yiv6677201616 #yiv6677201616ygrp-sponsor 
#yiv6677201616ygrp-lc {font-family:Arial;}#yiv6677201616 
#yiv6677201616ygrp-sponsor #yiv6677201616ygrp-lc #yiv6677201616hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6677201616 
#yiv6677201616ygrp-sponsor #yiv6677201616ygrp-lc .yiv6677201616ad 
{margin-bottom:10px;padding:0 0;}#yiv6677201616 #yiv6677201616actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6677201616 
#yiv6677201616activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6677201616
 #yiv6677201616activity span {font-weight:700;}#yiv6677201616 
#yiv6677201616activity span:first-child 
{text-transform:uppercase;}#yiv6677201616 #yiv6677201616activity span a 
{color:#5085b6;text-decoration:none;}#yiv6677201616 #yiv6677201616activity span 
span {color:#ff7900;}#yiv6677201616 #yiv6677201616activity span 
.yiv6677201616underline {text-decoration:underline;}#yiv6677201616 
.yiv6677201616attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv6677201616 .yiv6677201616attach div a 
{text-decoration:none;}#yiv6677201616 .yiv6677201616attach img 
{border:none;padding-right:5px;}#yiv6677201616 .yiv6677201616attach label 
{display:block;margin-bottom:5px;}#yiv6677201616 .yiv6677201616attach label a 
{text-decoration:none;}#yiv6677201616 blockquote {margin:0 0 0 
4px;}#yiv6677201616 .yiv6677201616bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv6677201616 
.yiv6677201616bold a {text-decoration:none;}#yiv6677201616 dd.yiv6677201616last 
p a {font-family:Verdana;font-weight:700;}#yiv6677201616 dd.yiv6677201616last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6677201616 
dd.yiv6677201616last p span.yiv6677201616yshortcuts 
{margin-right:0;}#yiv6677201616 div.yiv6677201616attach-table div div a 
{text-decoration:none;}#yiv6677201616 div.yiv6677201616attach-table 
{width:400px;}#yiv6677201616 div.yiv6677201616file-title a, #yiv6677201616 
div.yiv6677201616file-title a:active, #yiv6677201616 
div.yiv6677201616file-title a:hover, #yiv6677201616 div.yiv6677201616file-title 
a:visited {text-decoration:none;}#yiv6677201616 div.yiv6677201616photo-title a, 
#yiv6677201616 div.yiv6677201616photo-title a:active, #yiv6677201616 
div.yiv6677201616photo-title a:hover, #yiv6677201616 
div.yiv6677201616photo-title a:visited {text-decoration:none;}#yiv6677201616 
div#yiv6677201616ygrp-mlmsg #yiv6677201616ygrp-msg p a 
span.yiv6677201616yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6677201616 
.yiv6677201616green {color:#628c2a;}#yiv6677201616 .yiv6677201616MsoNormal 
{margin:0 0 0 0;}#yiv6677201616 o {font-size:0;}#yiv6677201616 
#yiv6677201616photos div {float:left;width:72px;}#yiv6677201616 
#yiv6677201616photos div div {border:1px solid 
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv6677201616 
#yiv6677201616photos div label 
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6677201616
 #yiv6677201616reco-category {font-size:77%;}#yiv6677201616 
#yiv6677201616reco-desc {font-size:77%;}#yiv6677201616 .yiv6677201616replbq 
{margin:4px;}#yiv6677201616 #yiv6677201616ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv6677201616 #yiv6677201616ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6677201616 
#yiv6677201616ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6677201616 
#yiv6677201616ygrp-mlmsg select, #yiv6677201616 input, #yiv6677201616 textarea 
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv6677201616 
#yiv6677201616ygrp-mlmsg pre, #yiv6677201616 code {font:115% 
monospace;}#yiv6677201616 #yiv6677201616ygrp-mlmsg * 
{line-height:1.22em;}#yiv6677201616 #yiv6677201616ygrp-mlmsg #yiv6677201616logo 
{padding-bottom:10px;}#yiv6677201616 #yiv6677201616ygrp-msg p a 
{font-family:Verdana;}#yiv6677201616 #yiv6677201616ygrp-msg 
p#yiv6677201616attach-count span {color:#1E66AE;font-weight:700;}#yiv6677201616 
#yiv6677201616ygrp-reco #yiv6677201616reco-head 
{color:#ff7900;font-weight:700;}#yiv6677201616 #yiv6677201616ygrp-reco 
{margin-bottom:20px;padding:0px;}#yiv6677201616 #yiv6677201616ygrp-sponsor 
#yiv6677201616ov li a {font-size:130%;text-decoration:none;}#yiv6677201616 
#yiv6677201616ygrp-sponsor #yiv6677201616ov li 
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv6677201616 
#yiv6677201616ygrp-sponsor #yiv6677201616ov ul {margin:0;padding:0 0 0 
8px;}#yiv6677201616 #yiv6677201616ygrp-text 
{font-family:Georgia;}#yiv6677201616 #yiv6677201616ygrp-text p {margin:0 0 1em 
0;}#yiv6677201616 #yiv6677201616ygrp-text tt {font-size:120%;}#yiv6677201616 
#yiv6677201616ygrp-vital ul li:last-child {border-right:none 
!important;}#yiv6677201616   

Kirim email ke