Here is how I used conditional formatting in Word to solve a problem. One of our company's Word templates is a Call Tracking document. The document contains a table used to track Action Items related to customer calls. Each action item has a due date assigned to it. As the action item list grows, keeping track of approaching due dates and completion dates becomes more difficult.

We used the conditional formatting code as part of the document's Auto_Open procedure to check the due date of each action item and highlight rows where the due date is old (RED), where the due date is near or today (YELLOW), and when an item is complete (GREEN).

Our users love this new feature because it saves them time from manually highlighting items and automatically draws attention to past due and pending items.

James