Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) On Error Resume Next Cells.FormatConditions.Delete With Target.FormatConditions.Delete.Add xlExpression, , "TRUE".Item(1).Interior.ColorIndex = 35 End With End Sub