Feng Office Collaboration Platform enables you to: Manage your projects and business services Collaborate with your team and your customers Organize and share documents and files.

For some weird reason, I’ve been a Microsoft Excel addict for as long as I can remember. When I was younger I remember being told by one of my teachers that Excel is one of the most powerful applications available, but most people will never touch it with a ten foot pole.

For over 7 years I’ve been programming Visual Basic for Applications (VBA) in Excel, which is essentially a way to extend Excel to do everything your heart desires. With it you can add more formulas, and create buttons that will execute queries on the data located in your spreadsheet. VBA is one of Excel’s best features in my opinion.

What I’m going to cover today is how to highlight cells based on their values in Excel 2007. This method is extremely simple and doesn’t use an ounce of VBA, despite an abundance of sites out there saying that VBA is required to do such a task. It’s all about Conditional Formatting!

The Juice Analytics blog has a clever little Excel trick that creates a bar graph inside cells using the repeat (REPT) function.

Excuse me while I self-document something. I've been using Excel for years. I've done some crazy stuff with Excel. One of the more tame things that I've done is track my finances with it. I have a spreadsheet that I've entered all my bills and especially indicated all the ones that automatically withdraw from my bank account.

However, I want to know the next time they're going to come out. I can tell you the next time something will come out whether it's monthly, bi-weekly, or weekly. And I even have conditional formatting in place to colour code when things are more urgent.