Maaf Formulanya seharusnya begini: =COUNTIF($A$2:$A$27,$F2)>0
Wassalam ~ Bagus ~ ----- Original Message ----- From: Bagus To: [email protected] Sent: Wednesday, March 05, 2014 4:12 PM Subject: Re: [belajar-excel] membandingkan 2 table Hai Dowo; 1. Block F2:I2 2. Click Conditional Formatting pada ribbon Home 3. Pilih New Rule 4. Pilih Use a formula bla..bla..bla.. 5. Isikan formula berikut: =COUNTIF($A$2:$A$27,$F3)>0 6. Atur format sesuai keinginan, lalu OK 7. Block F2:I2, pencet tombol Ctrl+C (Copy) 8. Block F2:I24, paste special => Formats 9. Selesai Wassalam ~ Bagus ~ ----- Original Message ----- From: gantar dowo To: [email protected] Sent: Wednesday, March 05, 2014 3:37 PM Subject: [belajar-excel] membandingkan 2 table [1 Attachment] salam mohon bantuannya membandingkan tgl masuk pada 2 tabel berdasarkan NIK dengan menggunakan conditional formatting TIA
