[belajar-excel] Tabel Pengatur Warna [1 Attachment]

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

[belajar-excel] Tabel Pengatur Warna [1 Attachment]

Milis Belajar Excel mailing list
Assalamualaikum wrwb
Untuk kesekian kalinya..bagia ini saya nyerah untuk oprek dan mencoba karena ga ada bayangan sama sekali.Mohon bapak ibu bisa melihat lampirannya bisa lebih jelas..Untuk hal ini mohon tidak menggunakan macro
SalamSeismica

|  | Virus-free. www.avast.com  |


Tabel Pengatur Warna.xlsx (13K) Download Attachment
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [belajar-excel] Tabel Pengatur Warna [1 Attachment]

Milis Belajar Excel mailing list
Wasalamualaikum warahmatullah,

Coba pakai Conditional formating:

1. Letakkan cursor pada C3, pada  Tab Home, Group Styles, KLIk button
Conditional Formating.

2. PIlih New rules.

3. KLik Use a formula to determine which cells to format (gambar no 1)

4. Ketik formulanya di tempat: Format values where this formula is true
(gambar no 2)

=Match($C3;$A$3:$A$31;0)

Jangan lupa untuk mengubah tanda ; menjadi , jika setting komputer
setempat bukan Indonesia. dan yang berwarna merah dapat diganti sesuai
kebutuhan.

5. Klik Format, kemudian pilih fill dan warna merah (gambar no 3)

6. KLik OK

7. Copy format cell C3 ke C4 sampai C13 (dapat menggunakan format painter)

Waalaikumsalam warahmatullah.

NangAgus


On 8/1/2017 10:41 PM, Zerlinda Seismica [hidden email]
[belajar-excel] wrote:

> Assalamualaikum wrwb
>
> Untuk kesekian kalinya..bagia ini saya nyerah untuk oprek dan mencoba
> karena ga ada bayangan sama sekali.
> Mohon bapak ibu bisa melihat lampirannya bisa lebih jelas..
> Untuk hal ini mohon tidak menggunakan macro
>
> Salam
> Seismica
>
> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
> Virus-free. www.avast.com
> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
>
>
>


format1.jpg (92K) Download Attachment
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

RE: [belajar-excel] Tabel Pengatur Warna [1 Attachment]

Milis Belajar Excel mailing list
In reply to this post by Milis Belajar Excel mailing list
Walaikumsalam warahmatullah



Mungkin begini.

Sengaja jalannya dibikin 2 , pakai tabel bantu dan conditional formatting,

Supaya nambah wawasan.



Ade



*From:* [hidden email] [mailto:[hidden email]]

*Sent:* Tuesday, August 1, 2017 10:41 PM
*To:* [hidden email]
*Subject:* [belajar-excel] Tabel Pengatur Warna [1 Attachment]





Assalamualaikum wrwb



Untuk kesekian kalinya..bagia ini saya nyerah untuk oprek dan mencoba
karena ga ada bayangan sama sekali.

Mohon bapak ibu bisa melihat lampirannya bisa lebih jelas..

Untuk hal ini mohon tidak menggunakan macro



Salam

Seismica



[image: Image removed by sender.]
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>

Virus-free. www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>



image001.jpg (472 bytes) Download Attachment
image002.jpg (578 bytes) Download Attachment
image003.jpg (492 bytes) Download Attachment
image004.jpg (454 bytes) Download Attachment
Tabel Pengatur Warna-edited.xlsx (34K) Download Attachment
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Bls: [belajar-excel] Tabel Pengatur Warna [1 Attachment]

Milis Belajar Excel mailing list
Done....Alhamdulillah.....suwunnnn untuk semunya...

    Pada Rabu, 2 Agustus 2017 14:04, "'M.Ade Alfarid' [hidden email] [belajar-excel]" <[hidden email]> menulis:


 #yiv4789928541 #yiv4789928541 -- #yiv4789928541 .yiv4789928541ygrp-photo-title{clear:both;font-size:smaller;min-height:15px;overflow:hidden;text-align:center;width:75px;}#yiv4789928541 div.yiv4789928541ygrp-photo{background-position:center;background-repeat:no-repeat;background-color:white;border:1px solid black;min-height:62px;width:62px;}#yiv4789928541 div.yiv4789928541photo-title a, #yiv4789928541 div.yiv4789928541photo-title a:active, #yiv4789928541 div.yiv4789928541photo-title a:hover, #yiv4789928541 div.yiv4789928541photo-title a:visited {text-decoration:none;}#yiv4789928541 div.yiv4789928541attach-table div.yiv4789928541attach-row {clear:both;}#yiv4789928541 div.yiv4789928541attach-table div.yiv4789928541attach-row div {float:left;}#yiv4789928541 p {clear:both;padding:15px 0 3px 0;overflow:hidden;}#yiv4789928541 div.yiv4789928541ygrp-file {width:30px;}#yiv4789928541 div.yiv4789928541attach-table div.yiv4789928541attach-row div div a {text-decoration:none;}#yiv4789928541 div.yiv4789928541attach-table div.yiv4789928541attach-row div div span {font-weight:normal;}#yiv4789928541 div.yiv4789928541ygrp-file-title {font-weight:bold;}#yiv4789928541 #yiv4789928541 #yiv4789928541 #yiv4789928541 -- _filtered #yiv4789928541 {font-family:Helvetica;panose-1:2 11 6 4 2 2 2 2 2 4;} _filtered #yiv4789928541 {font-family:Wingdings;panose-1:5 0 0 0 0 0 0 0 0 0;} _filtered #yiv4789928541 {panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered #yiv4789928541 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #yiv4789928541 {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;} _filtered #yiv4789928541 {font-family:Verdana;panose-1:2 11 6 4 3 5 4 4 2 4;} _filtered #yiv4789928541 {font-family:Consolas;panose-1:2 11 6 9 2 2 4 3 2 4;} _filtered #yiv4789928541 {panose-1:2 11 5 3 2 1 2 2 2 4;}#yiv4789928541 #yiv4789928541 p.yiv4789928541MsoNormal, #yiv4789928541 li.yiv4789928541MsoNormal, #yiv4789928541 div.yiv4789928541MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;}#yiv4789928541 a:link, #yiv4789928541 span.yiv4789928541MsoHyperlink {color:blue;text-decoration:underline;}#yiv4789928541 a:visited, #yiv4789928541 span.yiv4789928541MsoHyperlinkFollowed {color:purple;text-decoration:underline;}#yiv4789928541 p {margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv4789928541 code {}#yiv4789928541 pre {margin:0in;margin-bottom:.0001pt;font-size:10.0pt;}#yiv4789928541 tt {}#yiv4789928541 span.yiv4789928541cat {}#yiv4789928541 span.yiv4789928541ct {}#yiv4789928541 span.yiv4789928541HTMLPreformattedChar {}#yiv4789928541 p.yiv4789928541attach, #yiv4789928541 li.yiv4789928541attach, #yiv4789928541 div.yiv4789928541attach {margin-right:0in;margin-left:0in;font-size:9.0pt;}#yiv4789928541 p.yiv4789928541bold, #yiv4789928541 li.yiv4789928541bold, #yiv4789928541 div.yiv4789928541bold {margin-right:0in;margin-left:0in;font-size:10.0pt;font-weight:bold;}#yiv4789928541 p.yiv4789928541green, #yiv4789928541 li.yiv4789928541green, #yiv4789928541 div.yiv4789928541green {margin-right:0in;margin-left:0in;font-size:12.0pt;color:#628C2A;}#yiv4789928541 p.yiv4789928541replbq, #yiv4789928541 li.yiv4789928541replbq, #yiv4789928541 div.yiv4789928541replbq {margin:3.0pt;font-size:12.0pt;}#yiv4789928541 p.yiv4789928541ad, #yiv4789928541 li.yiv4789928541ad, #yiv4789928541 div.yiv4789928541ad {margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv4789928541 p.yiv4789928541underline, #yiv4789928541 li.yiv4789928541underline, #yiv4789928541 div.yiv4789928541underline {margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv4789928541 span.yiv4789928541yshortcuts {}#yiv4789928541 p.yiv4789928541ad1, #yiv4789928541 li.yiv4789928541ad1, #yiv4789928541 div.yiv4789928541ad1 {margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv4789928541 p.yiv4789928541ad2, #yiv4789928541 li.yiv4789928541ad2, #yiv4789928541 div.yiv4789928541ad2 {margin-right:0in;margin-bottom:7.5pt;margin-left:0in;font-size:12.0pt;}#yiv4789928541 p.yiv4789928541underline1, #yiv4789928541 li.yiv4789928541underline1, #yiv4789928541 div.yiv4789928541underline1 {margin-right:0in;margin-left:0in;font-size:12.0pt;text-decoration:underline;}#yiv4789928541 span.yiv4789928541yshortcuts1 {font-weight:bold;}#yiv4789928541 span.yiv4789928541yshortcuts2 {font-weight:normal;}#yiv4789928541 span.yiv4789928541EmailStyle36 {color:#1D1B11;}#yiv4789928541 .yiv4789928541MsoChpDefault {font-size:10.0pt;} _filtered #yiv4789928541 {margin:1.0in 1.0in 1.0in 1.0in;}#yiv4789928541 div.yiv4789928541WordSection1 {}#yiv4789928541 _filtered #yiv4789928541 {} _filtered #yiv4789928541 {font-family:Symbol;}#yiv4789928541 ol {margin-bottom:0in;}#yiv4789928541 ul {margin-bottom:0in;}#yiv4789928541

Walaikumsalam warahmatullah Mungkin begini.Sengaja jalannya dibikin 2 , pakai tabel bantu dan conditional formatting,Supaya nambah wawasan. Ade From: [hidden email] [mailto:[hidden email]]
Sent: Tuesday, August 1, 2017 10:41 PM
To: [hidden email]
Subject: [belajar-excel] Tabel Pengatur Warna [1 Attachment]   Assalamualaikum wrwb Untuk kesekian kalinya..bagia ini saya nyerah untuk oprek dan mencoba karena ga ada bayangan sama sekali.Mohon bapak ibu bisa melihat lampirannya bisa lebih jelas..Untuk hal ini mohon tidak menggunakan macro SalamSeismica 
|  | Virus-free. www.avast.com  |






image001.jpg (476 bytes) Download Attachment
Loading...