[belajar-excel] Conditional Formating untuk Tanggal yang telah lewat dari Today [1 Attachment]

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

[belajar-excel] Conditional Formating untuk Tanggal yang telah lewat dari Today [1 Attachment]

ivan budiman
Dear Rekan2 BeExcel,
Mohon bantuannya, sudah beberapa kali saya coba, namun tidak berhasil.
Saya ingin melakukan conditional formating (highlight) untuk tanggal yang sudah lewat dari TODAY. Saya sudah coba, namun yang masih upcoming juga terhighlight. Apakah ada teman2 beExcel yang bisa bantu?
Terlampir filenya.
Terima kasih banyak atas bantuannya.
Regards,
M I B

- thankfulness -

=?UTF-8?b?Q29uZGl0aW9uYWwgRm9ybWF0aW5nLnhsc3g=?= (14K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Conditional Formating untuk Tanggal yang telah lewat dari Today [1 Attachment]

ghozi alkatiri
 blok seluruh tabel yang ingin ditarget mulai dari A3
tulis formula di conditional formating
=IF(A3<TODAY(),TRUE)

wassalam
Ghozi Alkatiri
    Pada Selasa, 5 Februari 2019 15.09.11 WIB, ivan budiman ivanstats@yahoo..com [belajar-excel] <[hidden email]> menulis:  
 
    

Dear Rekan2 BeExcel,
Mohon bantuannya, sudah beberapa kali saya coba, namun tidak berhasil.
Saya ingin melakukan conditional formating (highlight) untuk tanggal yang sudah lewat dari TODAY. Saya sudah coba, namun yang masih upcoming juga terhighlight. Apakah ada teman2 beExcel yang bisa bantu?
Terlampir filenya.
Terima kasih banyak atas bantuannya.
Regards,
M I B

- thankfulness -  #yiv9554728456 #yiv9554728456 -- #yiv9554728456ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9554728456 #yiv9554728456ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9554728456 #yiv9554728456ygrp-mkp #yiv9554728456hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9554728456 #yiv9554728456ygrp-mkp #yiv9554728456ads {margin-bottom:10px;}#yiv9554728456 #yiv9554728456ygrp-mkp .yiv9554728456ad {padding:0 0;}#yiv9554728456 #yiv9554728456ygrp-mkp .yiv9554728456ad p {margin:0;}#yiv9554728456 #yiv9554728456ygrp-mkp ..yiv9554728456ad a {color:#0000ff;text-decoration:none;}#yiv9554728456 #yiv9554728456ygrp-sponsor #yiv9554728456ygrp-lc {font-family:Arial;}#yiv9554728456 #yiv9554728456ygrp-sponsor #yiv9554728456ygrp-lc #yiv9554728456hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9554728456 #yiv9554728456ygrp-sponsor #yiv9554728456ygrp-lc .yiv9554728456ad {margin-bottom:10px;padding:0 0;}#yiv9554728456 #yiv9554728456actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9554728456 #yiv9554728456activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9554728456 #yiv9554728456activity span {font-weight:700;}#yiv9554728456 #yiv9554728456activity span:first-child {text-transform:uppercase;}#yiv9554728456 #yiv9554728456activity span a {color:#5085b6;text-decoration:none;}#yiv9554728456 #yiv9554728456activity span span {color:#ff7900;}#yiv9554728456 #yiv9554728456activity span .yiv9554728456underline {text-decoration:underline;}#yiv9554728456 .yiv9554728456attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9554728456 .yiv9554728456attach div a {text-decoration:none;}#yiv9554728456 ..yiv9554728456attach img {border:none;padding-right:5px;}#yiv9554728456 .yiv9554728456attach label {display:block;margin-bottom:5px;}#yiv9554728456 .yiv9554728456attach label a {text-decoration:none;}#yiv9554728456 blockquote {margin:0 0 0 4px;}#yiv9554728456 .yiv9554728456bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9554728456 .yiv9554728456bold a {text-decoration:none;}#yiv9554728456 dd.yiv9554728456last p a {font-family:Verdana;font-weight:700;}#yiv9554728456 dd.yiv9554728456last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9554728456 dd.yiv9554728456last p span.yiv9554728456yshortcuts {margin-right:0;}#yiv9554728456 div.yiv9554728456attach-table div div a {text-decoration:none;}#yiv9554728456 div.yiv9554728456attach-table {width:400px;}#yiv9554728456 div.yiv9554728456file-title a, #yiv9554728456 div.yiv9554728456file-title a:active, #yiv9554728456 div.yiv9554728456file-title a:hover, #yiv9554728456 div.yiv9554728456file-title a:visited {text-decoration:none;}#yiv9554728456 div.yiv9554728456photo-title a, #yiv9554728456 div.yiv9554728456photo-title a:active, #yiv9554728456 div.yiv9554728456photo-title a:hover, #yiv9554728456 div.yiv9554728456photo-title a:visited {text-decoration:none;}#yiv9554728456 div#yiv9554728456ygrp-mlmsg #yiv9554728456ygrp-msg p a span.yiv9554728456yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9554728456 .yiv9554728456green {color:#628c2a;}#yiv9554728456 .yiv9554728456MsoNormal {margin:0 0 0 0;}#yiv9554728456 o {font-size:0;}#yiv9554728456 #yiv9554728456photos div {float:left;width:72px;}#yiv9554728456 #yiv9554728456photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv9554728456 #yiv9554728456photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9554728456 #yiv9554728456reco-category {font-size:77%;}#yiv9554728456 #yiv9554728456reco-desc {font-size:77%;}#yiv9554728456 .yiv9554728456replbq {margin:4px;}#yiv9554728456 #yiv9554728456ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9554728456 #yiv9554728456ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9554728456 #yiv9554728456ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9554728456 #yiv9554728456ygrp-mlmsg select, #yiv9554728456 input, #yiv9554728456 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9554728456 #yiv9554728456ygrp-mlmsg pre, #yiv9554728456 code {font:115% monospace;}#yiv9554728456 #yiv9554728456ygrp-mlmsg * {line-height:1.22em;}#yiv9554728456 #yiv9554728456ygrp-mlmsg #yiv9554728456logo {padding-bottom:10px;}#yiv9554728456 #yiv9554728456ygrp-msg p a {font-family:Verdana;}#yiv9554728456 #yiv9554728456ygrp-msg p#yiv9554728456attach-count span {color:#1E66AE;font-weight:700;}#yiv9554728456 #yiv9554728456ygrp-reco #yiv9554728456reco-head {color:#ff7900;font-weight:700;}#yiv9554728456 #yiv9554728456ygrp-reco {margin-bottom:20px;padding:0px;}#yiv9554728456 #yiv9554728456ygrp-sponsor #yiv9554728456ov li a {font-size:130%;text-decoration:none;}#yiv9554728456 #yiv9554728456ygrp-sponsor #yiv9554728456ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv9554728456 #yiv9554728456ygrp-sponsor #yiv9554728456ov ul {margin:0;padding:0 0 0 8px;}#yiv9554728456 #yiv9554728456ygrp-text {font-family:Georgia;}#yiv9554728456 #yiv9554728456ygrp-text p {margin:0 0 1em 0;}#yiv9554728456 #yiv9554728456ygrp-text tt {font-size:120%;}#yiv9554728456 #yiv9554728456ygrp-vital ul li:last-child {border-right:none !important;}#yiv9554728456  

=?UTF-8?b?Z2hvemkwNTAyMjAxOUNvbmRpdGlvbmFsIEZvcm1hdGluZy54bHN4?= (16K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Conditional Formating untuk Tanggal yang telah lewat dari Today

ivan budiman
Dear Pak Ghozi,
Terima kasih banyak ya Pak atas bantuannya 🙏🙏🙏

Sent from Yahoo Mail on Android
 
  On Tue, Feb 5, 2019 at 4:53 PM, ghozi alkatiri [hidden email] [belajar-excel]<[hidden email]> wrote:      

 blok seluruh tabel yang ingin ditarget mulai dari A3
tulis formula di conditional formating
=IF(A3<TODAY(),TRUE)

wassalam
Ghozi Alkatiri
    Pada Selasa, 5 Februari 2019 15.09.11 WIB, ivan budiman ivanstats@yahoo..com [belajar-excel] <[hidden email]> menulis:  
 
    

Dear Rekan2 BeExcel,
Mohon bantuannya, sudah beberapa kali saya coba, namun tidak berhasil.
Saya ingin melakukan conditional formating (highlight) untuk tanggal yang sudah lewat dari TODAY. Saya sudah coba, namun yang masih upcoming juga terhighlight. Apakah ada teman2 beExcel yang bisa bantu?
Terlampir filenya.
Terima kasih banyak atas bantuannya.
Regards,
M I B

- thankfulness -      #yiv9881941904 #yiv9881941904 -- #yiv9881941904ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9881941904 #yiv9881941904ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9881941904 #yiv9881941904ygrp-mkp #yiv9881941904hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9881941904 #yiv9881941904ygrp-mkp #yiv9881941904ads {margin-bottom:10px;}#yiv9881941904 #yiv9881941904ygrp-mkp .yiv9881941904ad {padding:0 0;}#yiv9881941904 #yiv9881941904ygrp-mkp .yiv9881941904ad p {margin:0;}#yiv9881941904 #yiv9881941904ygrp-mkp .yiv9881941904ad a {color:#0000ff;text-decoration:none;}#yiv9881941904 #yiv9881941904ygrp-sponsor #yiv9881941904ygrp-lc {font-family:Arial;}#yiv9881941904 #yiv9881941904ygrp-sponsor #yiv9881941904ygrp-lc #yiv9881941904hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9881941904 #yiv9881941904ygrp-sponsor #yiv9881941904ygrp-lc .yiv9881941904ad {margin-bottom:10px;padding:0 0;}#yiv9881941904 #yiv9881941904actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9881941904 #yiv9881941904activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9881941904 #yiv9881941904activity span {font-weight:700;}#yiv9881941904 #yiv9881941904activity span:first-child {text-transform:uppercase;}#yiv9881941904 #yiv9881941904activity span a {color:#5085b6;text-decoration:none;}#yiv9881941904 #yiv9881941904activity span span {color:#ff7900;}#yiv9881941904 #yiv9881941904activity span .yiv9881941904underline {text-decoration:underline;}#yiv9881941904 .yiv9881941904attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9881941904 .yiv9881941904attach div a {text-decoration:none;}#yiv9881941904 .yiv9881941904attach img {border:none;padding-right:5px;}#yiv9881941904 .yiv9881941904attach label {display:block;margin-bottom:5px;}#yiv9881941904 .yiv9881941904attach label a {text-decoration:none;}#yiv9881941904 blockquote {margin:0 0 0 4px;}#yiv9881941904 .yiv9881941904bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9881941904 .yiv9881941904bold a {text-decoration:none;}#yiv9881941904 dd.yiv9881941904last p a {font-family:Verdana;font-weight:700;}#yiv9881941904 dd.yiv9881941904last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9881941904 dd.yiv9881941904last p span.yiv9881941904yshortcuts {margin-right:0;}#yiv9881941904 div.yiv9881941904attach-table div div a {text-decoration:none;}#yiv9881941904 div..yiv9881941904attach-table {width:400px;}#yiv9881941904 div.yiv9881941904file-title a, #yiv9881941904 div.yiv9881941904file-title a:active, #yiv9881941904 div.yiv9881941904file-title a:hover, #yiv9881941904 div.yiv9881941904file-title a:visited {text-decoration:none;}#yiv9881941904 div.yiv9881941904photo-title a, #yiv9881941904 div.yiv9881941904photo-title a:active, #yiv9881941904 div.yiv9881941904photo-title a:hover, #yiv9881941904 div.yiv9881941904photo-title a:visited {text-decoration:none;}#yiv9881941904 div#yiv9881941904ygrp-mlmsg #yiv9881941904ygrp-msg p a span.yiv9881941904yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9881941904 .yiv9881941904green {color:#628c2a;}#yiv9881941904 .yiv9881941904MsoNormal {margin:0 0 0 0;}#yiv9881941904 o {font-size:0;}#yiv9881941904 #yiv9881941904photos div {float:left;width:72px;}#yiv9881941904 #yiv9881941904photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv9881941904 #yiv9881941904photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9881941904 #yiv9881941904reco-category {font-size:77%;}#yiv9881941904 #yiv9881941904reco-desc {font-size:77%;}#yiv9881941904 .yiv9881941904replbq {margin:4px;}#yiv9881941904 #yiv9881941904ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9881941904 #yiv9881941904ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9881941904 #yiv9881941904ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9881941904 #yiv9881941904ygrp-mlmsg select, #yiv9881941904 input, #yiv9881941904 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9881941904 #yiv9881941904ygrp-mlmsg pre, #yiv9881941904 code {font:115% monospace;}#yiv9881941904 #yiv9881941904ygrp-mlmsg * {line-height:1.22em;}#yiv9881941904 #yiv9881941904ygrp-mlmsg #yiv9881941904logo {padding-bottom:10px;}#yiv9881941904 #yiv9881941904ygrp-msg p a {font-family:Verdana;}#yiv9881941904 #yiv9881941904ygrp-msg p#yiv9881941904attach-count span {color:#1E66AE;font-weight:700;}#yiv9881941904 #yiv9881941904ygrp-reco #yiv9881941904reco-head {color:#ff7900;font-weight:700;}#yiv9881941904 #yiv9881941904ygrp-reco {margin-bottom:20px;padding:0px;}#yiv9881941904 #yiv9881941904ygrp-sponsor #yiv9881941904ov li a {font-size:130%;text-decoration:none;}#yiv9881941904 #yiv9881941904ygrp-sponsor #yiv9881941904ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv9881941904 #yiv9881941904ygrp-sponsor #yiv9881941904ov ul {margin:0;padding:0 0 0 8px;}#yiv9881941904 #yiv9881941904ygrp-text {font-family:Georgia;}#yiv9881941904 #yiv9881941904ygrp-text p {margin:0 0 1em 0;}#yiv9881941904 #yiv9881941904ygrp-text tt {font-size:120%;}#yiv9881941904 #yiv9881941904ygrp-vital ul li:last-child {border-right:none !important;}#yiv9881941904