I'm sorry. It's not proper manner to reply so late to people like you helping random guys. I'm really sorry work's been so busy that I could hardly post here. Really sorry.

A few days ago I tested it in the workplace. The problem is at home (Excel 2010) it (conditional formatting) works but in Excel 2007, the formatting doesn't.