fill color

  • Thread starter Thread starter JD
  • Start date Start date
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
 
Assuming you have a fill color in the cell first try
format>conditional format>formula is>=c1<>"">format to no 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Macro to automatically go to the right of the last colored cell 0
Excel VBA 1
Cell fill color in linked cells? 1
Can RGB fill color be automated based on 3 cell values? 2
GRIDLINES 7 FILL COLOR 4
How do I keep fill color constant when cut & copying text? 4
Standard Colors 1
How do I stop Excel from copying date format from cell above? 2

Back
Top