fill color

J

JD

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
 
D

Don Guillett

Assuming you have a fill color in the cell first try
format>conditional format>formula is>=c1<>"">format to no color>>
 
O

Otto Moehrbach

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
 
Top