Re: ]] XL-mania [[ Formula "if" untuk mengidentifikasi border diagonal

 

ya bisa lah...

misal
di cell A1 ada border diagonal nya
di cell A2  tidak ada border diagonalnya

tuliskan di sebelahnya (Cell B1) formula sbb
=IF(BorderDiagonal(A1),"ada border diagonalnya","ndak ada border diagonalnya")
truss copykan formula ke B2;  dan lihat apa yang terjadi !!

Jika formulanya hanya  =BorderDiagonal(A1)  doWang..
hasilnya bisa TRUE atau FALSE tergantung apakah di cell yg dirujuk ada
diagonal-border-nya atau tidak.

tetapi.. semua yg tertulis di atas itu hanya omong kosong (tidak akan terbukti)
kalau di module standar pada workbook anda belum ada code prosedur UDF spt ini

Function BorderDiagonal(X As Range) As Boolean
   BorderDiagonal = _
   (X.Borders(5).LineStyle > 0 Or _
    X.Borders(6).LineStyle > 0)
End Function

bluewater 28jun2010
siti

On Sun, Jun 27, 2010 at 8:46 PM, ali_fatkhuri@yahoo.com <ali_fatkhuri@yahoo.com> wrote:

Dear expert xl, saya mau nanya apakah bisa formula "if" mengidentifikasi kalau cell ada border diagonal, karena data saya pembedanya dgn cell2 yg border diagonal. Atau mungkin dgn macro?mohon sarannya. Terima kasih  ..Ali

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (2)

Recent Activity:

• New Members 134

Visit Your Group

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| jangan lupa sebelum bertanya, cek dulu www.XL-mania.com dan       |
| http://tech.groups.yahoo.com/group/XL-mania/messages              |
| 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

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

---

Get great advice about dogs and cats. Visit the Dog & Cat Answers Center.

---

Get real-time World Cup coverage on the Yahoo! Toolbar. Download now to win a signed team jersey!

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___