JD
You will need VBA for that. Put the following macro in the sheet module
of your sheet. This macro will remove the fill color in any cell on the
sheet when any entry is made into that cell. HTH Otto
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count 1 Then Exit Sub
If Not IsEmpty(Target.Value) Then _
Target.Interior.ColorIndex = xlNone
End Sub
"JD" wrote in message
...
Is it possible to format a spreadsheet to remove the fill color of each
cell
once data has been entered into that cell? How?

Thanks

--
JD