private void dataGridView1_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
        {
            if (e.Value.ToString() == "yes")
            {
                e.CellStyle.ForeColor = Color.Red;
            }
        }

------解决方案--------------------
楼上正解！