Bill,

Now that I understand your question, I woudl think you can reference the other cell and set those same values with these right in the code you have.

this.dataGridViewTrackingSearch.CurrentRow.Cells["ColumnSono"].Style.BackColor = Color.Blue;
this.dataGridViewTrackingSearch.CurrentRow.Cells["ColumnSono"].Style.SelectionBackColor = Color.Aqua;

Tim

>The code below sets the backcolor of the ColumnHasComments column to Red if the source data table record has "Y" in the hascomment field.
>That works fine.
>How would I set the backcolor of another column (ColumnSono) to Red for the same condition (hascomment = "Y")
>
>
>

> private void dataGridViewTrackingSearch_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
>     {
>       if (dataGridViewTrackingSearch.Columns[e.ColumnIndex].Name.Equals("ColumnHasComment"))
>       {
>         if (e.Value != null)
>         {
>          
>           if (e.Value.ToString() == "Y")
>           {
>             e.CellStyle.BackColor = Color.Red;
>             e.CellStyle.SelectionBackColor = Color.DarkRed;
>           }
>         }
>       } 
>     } // end CellFormatting
>