Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fill color and font color icons do not work in excel | Excel Discussion (Misc queries) | |||
color fill button is not adding color to my spread sheet | Excel Worksheet Functions | |||
My fill color and font color do not work in Excel Std Edition 2003 | Excel Discussion (Misc queries) | |||
Excel 2003 will not display color fonts or color fill cells | Excel Worksheet Functions | |||
My excel 2003 wont let me fill cells with color or color the tabs. | New Users to Excel |