Option Explicit Sub aaa() Dim cell For Each cell In ActiveWorkbook.ActiveSheet.Range("A5:P15").Cells cell.Interior.Color = cell.DisplayFormat.Interior.Color cell.FormatConditions.Delete Next End Sub