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
National Instruments website has an example spreadsheet that can accomplish
this:
http://zone.ni.com/devzone/cda/epd/p/id/798
I've expanded the ni-488.2_in_excel.xls spreadsheet from this website to do
just about anything you want to with test equipment over GPIB.
-Brian
--