One of the new features in ITScriptNet 3.1a is the ability to automatically format grid cells. You can specify the color to use for a cell based on a comparison to a value or another cell.  You can also specify the number of decimal points to use for numeric data, and the format to use for negative numbers.

Here is an example of a program using grid auto-formatting. 

This Physical Inventory program shows the count of items.  Any items with a zero quantity are displayed in yellow, and negative quantities are red.  In adition, the Value field is set to use 2 decimal places and a $ currency prefix.  The source data looks like this:

Here is the Grid Cell definition screen in the ITScriptNet program designer.  You can see that the Automatic Formatting for the cell, and the Automatic Coloring.  Two coloring criteria can be specified for the cell.

These automatic cell formatting options allow you to make your data collection programs more effective through the use of color and formatting, without needing any complicated programming.