Sub Macro1()
With Application.FindFormat.Interior
.Pattern = xlSolid: .Color = 16749054
End With
Application.FindFormat.Locked = True
Application.FindFormat.FormulaHidden = False
Cells.FindNext(After:=Cells(1)).Activate
Cells.Replace What:="", Replacement:="0", LookAt:=xlPart, SearchOrder:=xlByColumns, MatchCase:=False, SearchFormat:=True, ReplaceFormat:=False
End Sub