DataGridView CellValidating event unexplained functionality

[systeko]

Hello,


I have one little problem which make me crazy. I've made application (for Windows) in Visual C#. On one panel I've got datagridview control which is not bind to database, I populate it manualy. It has 4 columns and only one can be edited and user can put some numbers in it (It is float type). I want to validate ie. to check if that value is in some boundaries (min and max value is in 2. and 3. column and column for editing is 1.). If value is out of that min-max range back color of that cell should change when I leave it. Nothing else. Here is the code:

private void dataGridView1_CellValidating(object sender, System.Windows.Forms.DataGridViewCellValidatingEventArgs e)
        {
            try
            {
 
                if (e.ColumnIndex == 1)
                {
 
                    if (dataGridView1[e.ColumnIndex, e.RowIndex].Value != (Object)"")
                    {
 
                        float pom = float.Parse(Convert.ToString(dataGridView1[e.ColumnIndex, e.RowIndex].Value));
                        if (Convert.ToSingle(dataGridView1[e.ColumnIndex, e.RowIndex].Value) < 0) throw new FormatException();
 
                        if ((Convert.ToSingle(dataGridView1[e.ColumnIndex, e.RowIndex].Value) < Convert.ToSingle(dataGridView1[2, e.RowIndex].Value)) | (Convert.ToSingle(dataGridView1[e.ColumnIndex, e.RowIndex].Value) > Convert.ToSingle(dataGridView1[3, e.RowIndex].Value)))
                            dataGridView1[e.ColumnIndex, e.RowIndex].Style.BackColor = Color.MistyRose;
                        else
                            dataGridView1[e.ColumnIndex, e.RowIndex].Style.BackColor = SystemColors.Window;
                    }
 
                }
 
            }
            catch (FormatException fe)
            {
                MessageBox.Show("Something", "Something", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }
 
 
        }

My problem is that when first time I entering numbers in cell and I go to other cell ie. cell loses focus, cell validating event is fired, but the value of that cell I left is empty string, "". It isn't that that I typed. If I, after that, reenter same cell and again get out from it, only then the value of cell will be adequate and the back color of the cell would change if it is out of range. And the reason for this is not in the line:

 if (dataGridView1[e.ColumnIndex, e.RowIndex].Value != (Object)"") 

because the same is happening without it, and I put it in the code to avoid showing messagebox from catch segment every first time when I leaving the cell. If there isn't that line float.Parse or Convert.tosingle will raise FormatException event in every case.

Can somebody help me because without this I must to color cells on the button_click event which isn't functional.

Thanks!