Tecnologia, programação e muito Visual FoxPro.

quarta-feira, 22 de dezembro de 2010

Re: ]] XL-mania [[ autoformating

 

Hai Tbb,

Kata bapak Tb kalo kaya gini namanya conditional formatting.
(namanya sapa ya...)

Gambar dalam file terlampir untuk membuat conditional formatting di C4.
Pilih cell C4, ribbon (menu) Home -> Conditional Formatting ->New -> set seperti gambar

Copy ke cell lain yang sewarna.

Buat baru untuk warna lainnya, sesuaikan rujukan formulanya.

Regards.
Kid.

2010/12/22 Tbb-Cikarang, Tpm-Facilitator <TPM-Facilitator.TBB-Cikarang@unilever.com>
 

Dear Para pakar XL..

 

Mohon bantuannya nih..

Bagaimana menggunakan autoformating di Microsoft exel 2007

 

Thanks untuk pencerahannya..

 


__._,_.___
Recent Activity:
+-:: XL-mania ::::::::::::::::::::----------------------------------+
| sOrRy dOrRy j3K... m0m0dS LaGi HeC-tiC... waQaQaQa...             |
| http://www.facebook.com/group.php?gid=37671048001&ref=mf          |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message,  melecehkan,  tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan  winzip  jika  perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke  |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/           |
+-------------------------------------------------------------------+
| Berikan testimoni di : http://www.friendster.com/xlmania atau...  |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html           |
+-------------------------------------------------------------------+
| Message lama ada di :                                             |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id]  |
| http://www.mail-archive.com/xl-mania@yahoogroups.com              |
+-------------------------------------------------------------------+
MARKETPLACE

Find useful articles and helpful tips on living with Fibromyalgia. Visit the Fibromyalgia Zone today!


Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.


Hobbies & Activities Zone: Find others who share your passions! Explore new interests.

.

__,_._,___

Nenhum comentário:

Arquivo do blog