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
