Programatically sort and highlight
 

I have a worksheet of data that is dumped from our ERP system. It will have
cells that look blank but actually have "spaces" in them, alot of cells look
like this. The structure is as follows.

Columns

A B C D
9 H 12/1/09 2.00
9 H 12/1/08 3.00
9 H 10/1/09 4.00
9 U 11/1/09 5.00
9 U 2/1/09 6.00
Total for

What I think I want to do is search for the words "Total for" which will
then give me the very last line of data. Then within this range from 1 - to
the row that contains "Total For" I want to look at each cell in column C and
if the date is over six months old I want the whole row (A-D) to be
highlighted in yellow. This way it will bring attention to the item. I had
tried a for/while loop but it was not working correctly. Please help