fill color
 

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

fill color
 

Assuming you have a fill color in the cell first try
formatconditional formatformula is=c1<""format to no color

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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

fill color
 

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