You have to add just a little code in you current code:
private void Audit_Dg_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
if (e.ColumnIndex == 7 || e.ColumnIndex == 8 || e.ColumnIndex == 10 || e.ColumnIndex == 11 && e.RowIndex >= 0)
{
DataGridViewCell cell = this.Audit_Dg.Rows[e.RowIndex].Cells[e.ColumnIndex];
cell.ToolTipText = "Click Here To View The Message";
}
else
{
cell.ToolTipText = String.Empty;
}
}