If you are using Excel 2007, then you can do part of this without VBA. If
you want to change color of cell, for example, when the cell value is
negative, you can accomplish this by going to Home > Conditional Formatting
and then creating a rule by which the cell changes. This is probably easie
Simply searching the group for pdf to excel would've given you several
potential answers. I did not check this URL but here is one possible
software answer.
Link to answer:
http://groups.google.com/group/excel-macros/browse_thread/thread/b6fae3eee31606ec/d32d131c316fa8d4?lnk=gst&q=pdf+to+excel#d32