setting cellformat for cells containing formulas

When you programmatically change the grid, call grid.Recalc; after all your changes are done. (This reduces recalculations when you do multiple updates and call Recalc just once)