Pak A Hamid 1.. Kita select A1 dulu, buat / edit kondisional format seperti tadi itu"contoh pak joko", cuman hilangkan lambang dollarnya =$B$1 menjadi menjadi =B1 ( kita khan pake rupiah, gak pake dollar he he he ) 2.. copy >paste special> format ke cell dibawahnya 3.. jadi deh, dian
----- Original Message ----- From: Abdul To: [email protected] Sent: Monday, June 30, 2008 11:28 AM Subject: Re: [belajar-excel] Conditional Formating Pak Joko yth, Terima kasih bantuannya, tapi yang saya maksud bila : Sell a1 > b1 Merah a1 < b1 biru Sell a2 > b2 Merah a2 < b2 biru Sell a3 > b3 Merah a3 < b3 biru Sell a4 > b4 Merah a4 < b4 biru dan seterusnya Yang saya lihat di sell A2 sd sell A10 bila saya masuk dalam conditional formating nilai yang diambil hanya =$B$1, dan bila sell b1 saya ganti nilainya 1.000.000,- formatnya jadi biru semuanya . Thanks Abdul Hamid ----- Original Message ----- From: Nugroho, Djoko To: [email protected] Sent: Monday, June 30, 2008 10:46 AM Subject: RE: [belajar-excel] Conditional Formating Pak Abdul, Sy coba bantu jawab,.. (see attached) -joko- -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Abdul Sent: Saturday, June 28, 2008 10:11 AM To: [email protected] Subject: [belajar-excel] Conditional Formating Dear All, Bagaimana cara membuat Conditioanal formating dalam colum A apabila colum A > dari colum B dibuat format warna Merah dan bila Colum A < dari colum B dibuat format warna Biru, dengan mengcopy dari sell A1 sampai kebawah akan menghasilkan format yang sama. Wassalam Abdul Hamid DISCLAIMER --------------- "This email and any files transmitted with it are private and confidential and intended solely for the use of the individual or entity to which they are addressed. If you have received this email in error please notify the system manager. If you are not an intended recipient, you are hereby notified that any disclosure, copying, or distribution of this email, and/or taking any action based on its content, is strictly prohibited, and you should: (i) immediately delete this email and its attachments from your system, and (ii) inform the sender by reply email that you are not an intended recipient. Please note that any views or opinions presented in this email are solely those of the author/sender and do not necessarily represent those of ANJ Agri Group. ANJ Agri Group does not accept (i) any liability for its employee's communications that are against ANJ Agri's core values and/or outside the scope of employment and (ii) any damage caused by any virus transmitted by this email. Details can be found at: http://www.anjagri.com/disclaimer.htm"; DISCLAIMER --------------- "This email and any files transmitted with it are private and confidential and intended solely for the use of the individual or entity to which they are addressed. If you have received this email in error please notify the system manager. If you are not an intended recipient, you are hereby notified that any disclosure, copying, or distribution of this email, and/or taking any action based on its content, is strictly prohibited, and you should: (i) immediately delete this email and its attachments from your system, and (ii) inform the sender by reply email that you are not an intended recipient. Please note that any views or opinions presented in this email are solely those of the author/sender and do not necessarily represent those of ANJ Agri Group. ANJ Agri Group does not accept (i) any liability for its employee's communications that are against ANJ Agri's core values and/or outside the scope of employment and (ii) any damage caused by any virus transmitted by this email. Details can be found at: http://www.anjagri.com/disclaimer.htm";
