I need to develop a tool that enforces strict format of some table. The fields in this table follow specified patterns like number:number (11:20. 2:00), agreed date (11/20/2012 but not locale-dependent), a single integer, a single floating point value and so on.
The table should reject wrong values or highlight them in red. Apart that, the user must be capable of freely navigating and editing the table (allowing to add data just through some form in popup dialog looks like an awful solution).
Before starting to write a custom application, I would like to ask, how difficult is to implement this requirement in MS Excel, using document templates? I did some googling but without direct hit.
Using some other tool that easily supports this feature would also be acceptable.
Extension: here seems also an example how to use regular expressions.