I learned an Excel trick today - that doesn't happen very often. What I needed to do, was highlight values in a table if the value existed in another range on the sheet. How I did this was:

• Select the cells to apply the formatting to.
• Click the Conditional Formatting icon (Office 2007) in the toolbar
• Select "New Rule" and then the "Use a Formula..." option
• Enter "=VLOOKUP($B5,$AH$5:$AH$76,1,FALSE)" where $B5 is the first dynamic cell (the one that will be changing down the rows) and $AH$5:$AH$76 is the range in which to search for the value.
• Pick your formatting options

In a couple hours, Julene and I are meeting with our potential home builder to discuss our options. In all likely hood, we will need to put our house up for sale very shortly in order to satisfy their requirements. What it comes down to is that they don't want us to try and sell our house too late so they won't be out of pocket when the house is finished. They want us to list our house right away. We really don't want to move twice, but that may be our only option. A quick browse of available rentals reveals that renting is more expensive than owning. 

I've added more pictures finally. I only seem to do this when prompted by friends overseas.