cukup di kasi kondisi sum(d - j) - sisa utang aja kan? bukannya dah ketahuan?
________________________________ From: Adhe Tirtana <[email protected]> To: "[email protected]" <[email protected]> Sent: Tuesday, October 4, 2011 10:37 AM Subject: ]] XL-mania [[ Conditional Format berwarna Dear jagoan Excel sy baru belajar excel nih...mau tanya bgm caranya: dari list utang sy, sy mau ngecek data mana sj yg nilai di kolom "sisa utang" tdk sama dgn penjumlahan kolom "D+E+F+G+H+I" dan ditandai dgn warna Merah silahkan lihat attachment tks
