[belajar-excel] Conditional format hanya untuk data paling ujung

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

[belajar-excel] Conditional format hanya untuk data paling ujung

Supriyadi
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



1603598914565blob.jpg (27K) Download Attachment
Conditional format.xlsx (790K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Conditional format hanya untuk data paling ujung

Eka Subyantara-2
[image: image.png]
Barangkali ini yang dimaksudkan?

On Sun, Oct 25, 2020 at 11:09 AM Supriyadi [hidden email]
[belajar-excel] <[hidden email]> 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
> [image: Jadikan gambar sebaris]
>
>
>

1603598914565blob.jpg (27K) Download Attachment
image.png (87K) Download Attachment
Eka - Conditional format ujung.xlsx (839K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Bls: Re: [belajar-excel] Conditional format hanya untuk data pali

Supriyadi
Betul sekali bang, terima kasih ya bang
Best regard,
Supriyadi

Dikirim dari Yahoo Mail di Android
 
  Pada Min, 25 Okt 2020 pada 13:19, Eka Subyantara [hidden email] [belajar-excel]<[hidden email]> menulis:      


Barangkali ini yang dimaksudkan?
On Sun, Oct 25, 2020 at 11:09 AM Supriyadi [hidden email] [belajar-excel] <[hidden email]> 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




   
  #yiv3561737964 #yiv3561737964 -- #yiv3561737964ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3561737964 #yiv3561737964ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3561737964 #yiv3561737964ygrp-mkp #yiv3561737964hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3561737964 #yiv3561737964ygrp-mkp #yiv3561737964ads {margin-bottom:10px;}#yiv3561737964 #yiv3561737964ygrp-mkp .yiv3561737964ad {padding:0 0;}#yiv3561737964 #yiv3561737964ygrp-mkp .yiv3561737964ad p {margin:0;}#yiv3561737964 #yiv3561737964ygrp-mkp .yiv3561737964ad a {color:#0000ff;text-decoration:none;}#yiv3561737964 #yiv3561737964ygrp-sponsor #yiv3561737964ygrp-lc {font-family:Arial;}#yiv3561737964 #yiv3561737964ygrp-sponsor #yiv3561737964ygrp-lc #yiv3561737964hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3561737964 #yiv3561737964ygrp-sponsor #yiv3561737964ygrp-lc .yiv3561737964ad {margin-bottom:10px;padding:0 0;}#yiv3561737964 #yiv3561737964actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3561737964 #yiv3561737964activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3561737964 #yiv3561737964activity span {font-weight:700;}#yiv3561737964 #yiv3561737964activity span:first-child {text-transform:uppercase;}#yiv3561737964 #yiv3561737964activity span a {color:#5085b6;text-decoration:none;}#yiv3561737964 #yiv3561737964activity span span {color:#ff7900;}#yiv3561737964 #yiv3561737964activity span .yiv3561737964underline {text-decoration:underline;}#yiv3561737964 .yiv3561737964attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3561737964 .yiv3561737964attach div a {text-decoration:none;}#yiv3561737964 .yiv3561737964attach img {border:none;padding-right:5px;}#yiv3561737964 .yiv3561737964attach label {display:block;margin-bottom:5px;}#yiv3561737964 .yiv3561737964attach label a {text-decoration:none;}#yiv3561737964 blockquote {margin:0 0 0 4px;}#yiv3561737964 .yiv3561737964bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3561737964 .yiv3561737964bold a {text-decoration:none;}#yiv3561737964 dd.yiv3561737964last p a {font-family:Verdana;font-weight:700;}#yiv3561737964 dd.yiv3561737964last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3561737964 dd.yiv3561737964last p span.yiv3561737964yshortcuts {margin-right:0;}#yiv3561737964 div.yiv3561737964attach-table div div a {text-decoration:none;}#yiv3561737964 div.yiv3561737964attach-table {width:400px;}#yiv3561737964 div.yiv3561737964file-title a, #yiv3561737964 div.yiv3561737964file-title a:active, #yiv3561737964 div.yiv3561737964file-title a:hover, #yiv3561737964 div.yiv3561737964file-title a:visited {text-decoration:none;}#yiv3561737964 div.yiv3561737964photo-title a, #yiv3561737964 div.yiv3561737964photo-title a:active, #yiv3561737964 div.yiv3561737964photo-title a:hover, #yiv3561737964 div.yiv3561737964photo-title a:visited {text-decoration:none;}#yiv3561737964 div#yiv3561737964ygrp-mlmsg #yiv3561737964ygrp-msg p a span.yiv3561737964yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3561737964 .yiv3561737964green {color:#628c2a;}#yiv3561737964 .yiv3561737964MsoNormal {margin:0 0 0 0;}#yiv3561737964 o {font-size:0;}#yiv3561737964 #yiv3561737964photos div {float:left;width:72px;}#yiv3561737964 #yiv3561737964photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv3561737964 #yiv3561737964photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3561737964 #yiv3561737964reco-category {font-size:77%;}#yiv3561737964 #yiv3561737964reco-desc {font-size:77%;}#yiv3561737964 .yiv3561737964replbq {margin:4px;}#yiv3561737964 #yiv3561737964ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3561737964 #yiv3561737964ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3561737964 #yiv3561737964ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3561737964 #yiv3561737964ygrp-mlmsg select, #yiv3561737964 input, #yiv3561737964 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3561737964 #yiv3561737964ygrp-mlmsg pre, #yiv3561737964 code {font:115% monospace;}#yiv3561737964 #yiv3561737964ygrp-mlmsg * {line-height:1.22em;}#yiv3561737964 #yiv3561737964ygrp-mlmsg #yiv3561737964logo {padding-bottom:10px;}#yiv3561737964 #yiv3561737964ygrp-msg p a {font-family:Verdana;}#yiv3561737964 #yiv3561737964ygrp-msg p#yiv3561737964attach-count span {color:#1E66AE;font-weight:700;}#yiv3561737964 #yiv3561737964ygrp-reco #yiv3561737964reco-head {color:#ff7900;font-weight:700;}#yiv3561737964 #yiv3561737964ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3561737964 #yiv3561737964ygrp-sponsor #yiv3561737964ov li a {font-size:130%;text-decoration:none;}#yiv3561737964 #yiv3561737964ygrp-sponsor #yiv3561737964ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3561737964 #yiv3561737964ygrp-sponsor #yiv3561737964ov ul {margin:0;padding:0 0 0 8px;}#yiv3561737964 #yiv3561737964ygrp-text {font-family:Georgia;}#yiv3561737964 #yiv3561737964ygrp-text p {margin:0 0 1em 0;}#yiv3561737964 #yiv3561737964ygrp-text tt {font-size:120%;}#yiv3561737964 #yiv3561737964ygrp-vital ul li:last-child {border-right:none !important;}#yiv3561737964  

1603598914565blob.jpg (27K) Download Attachment
image.png (87K) Download Attachment