try this little macro:

Sub fillout()
For Each r In ActiveSheet.UsedRange
If Application.WorksheetFunction.IsText(r.Value) Then
Else
r.Interior.ColorIndex = lxnone
End If
Next
End Sub



--
Gary''s Student - gsnu200755


"Studebaker" wrote:

Hello,

I have a huge spreadsheet where I need to remove the lavender fill color
only on the cells that have no text in them. (I want to keep the lavender
fill color in the cells that do have text.)
I tried Find/Replace but it tried to remove the fill color for every cell.

Can someone help, please?

Thank you!